Toad World® Forums

Beta Released (13.0.0.43)

Beta Notes

Compare Schemas

Schema Compare is now threaded, so should not block other activities in Toad.

Formatting/Parsing (QP5)

Formatter

Fix (QP 2788) :

  • Distance between parameters and data types fixed to become exactly one indent (from one indent + one space). This change is due to a required major refactoring of the parameter declaration formatter code.
  • Stacked parameter declaration lists now have the IN, OUT, INOUT and NOCOPY keywords of their parameter declarations justified:

CREATE PROCEDURE astron.extern (
                         IN        a   DATE,
                        OUT        CHAR,
                        INOUT   c TIMESTAMP)

FUNCTION func1 (par1 INT,
par2 IN      INT := 3,
par3 INT := 3,
par4 IN OUT NOCOPY INT)

Code Analysis

Fix (QP 2800) : Rule 5914 (“Use untransformed column values in the WHERE clause.”)

  • Speedup (around 70 times) fixing possible multi-second delays.

  • Parameter specifications were not taken into account.
    Fix (QP 2786) : Rule 5920 (“Apply the invoker rights method to all stored code that executes dynamic SQL”)

  • Speedup (around 70 times) fixing possible multi-second delays.

The formatter examples should read as follows:

   CREATE PROCEDURE astron.extern (
IN a DATE,
OUT CHAR,
INOUT c TIMESTAMP)
FUNCTION func1 (par1 INT,
par2 IN INT := 3,
par3 INT := 3,
par4 IN OUT NOCOPY INT)