A script-enabled browser is required for this page to function properly.

Length Constraints Removed

In PL/SQL V2, the length Constraints on DATE, BOOLEAN, MLSLABEL, and ROWID are ignored. However, this causes compilation errors in V8.

To preserve V2 behavior, the PL/SQL conversion utility removes the Constraints.

Removing length Constraints Example

The conversion utility converts this code:

PROCEDURE badconstraint IS
d DATE(5);
b BOOLEAN(5);
d MLSLABEL(5); --V2 only
r ROWID(5); --V2 only
BEGIN
null;
END;

. . . to this:

PROCEDURE badconstraint IS
d DATE;
b BOOLEAN;
d MLSLABEL; --V2 only
r ROWID; --V2 only
BEGIN
null;
END;


About the PL/SQL V1 conversion utility