PLS-00230: OUT and IN OUT formal parameters may not have
default expressions



PLS-00230: OUT and IN OUT formal parameters may not have default expressions..

Answer / guest

Cause: When the formal parameters of a procedure were
declared, an OUT or IN OUT parameter was initialized to a
default value, as in PROCEDURE calc_bonus (bonus OUT REAL :=
0, ...) IS ... However, only IN parameters can be
initialized to default values.

Action: Remove the illegal default expression.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02058: no prepared transaction found with ID string

1 Answers  


ORA-06105: NETTCP: remote host is unknown

1 Answers  


ORA-16792: Some configurable property value is inconsistent with the database setting.

1 Answers  


NNF-04007: Error reading input file

1 Answers  


ORA-26679: operation not allowed on LOB or LONG columns in LCR

1 Answers  






EXP-00052: error on row number of partition string

1 Answers  


NZE-29154: deterministic RNG self-test failure

1 Answers  


ORA-38304: missing or invalid user name

1 Answers  


NID-00451: Succesfully changed database name.

1 Answers  


LPX-00601: Invalid token in: '~S'

1 Answers  


ORA-02308: invalid option string for object type column

1 Answers  


ORA-25001: cannot create this trigger type on views

1 Answers  


Categories