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

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

Removing default expressions Example

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 V1 conversion utility