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

PL/SQL conversion utility: Default expressions for OUT and IN OUT disallowed

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

Example: Removing 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;

See also

About the PL/SQL conversion utility