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.
The conversion utility converts this code:
PROCEDURE badconstraint IS d DATE(5); b BOOLEAN(5); d MLSLABEL(5);
--V2 onlyr ROWID(5);
--V2 onlyBEGIN null; END;
. . . to this:
PROCEDURE badconstraint IS d DATE; b BOOLEAN; d MLSLABEL;
--V2 onlyr ROWID;
--V2 onlyBEGIN null; END;
About the PL/SQL conversion utility
Copyright © 1984, 2005, Oracle. All rights reserved.