In PL/SQL V1, OUT
and IN OUT
parameters could be
followed by a default expression, although that expression was always ignored.
The conversion utility removes the default expressions for OUT
and IN OUT
parameters.
If you compile existing code that includes OUT
and IN OUT
parameters with default expressions, this error message is generated:
ERROR 230: OUT and IN OUT formal parameters may not have default
expressions
The conversion utility converts this PL/SQL V1 code:
PROCEDURE p (p1 IN OUT NUMBER DEFAULT 25,
p2 OUT NUMBER DEFAULT 16) IS
BEGIN
. . .
END;
. . . to this:
PROCEDURE p (p1 IN OUT NUMBER, p2 OUT NUMBER) IS
BEGIN
. . .
END;
About the PL/SQL conversion utility
Copyright © 1984, 2005, Oracle. All rights reserved.