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

NNL-00962: Cache checkpoint failures: number

1 Answers  


RMAN-06471: no configuration found to allocate channels for string

1 Answers  


PCC-02358: Identifier following ARRAYLEN must be the name of an array

1 Answers  


ORA-24815: Invalid character set form

1 Answers  


ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management

2 Answers  






ORA-16154: suspect attribute: string

1 Answers  


ORA-31428: no publication contains all the specified columns

1 Answers  


RMAN-00551: initialization of parser package failed

1 Answers  


ORA-29396: cannot switch group to string

1 Answers  


ORA-13146: could not find table substitution variable string

1 Answers  


ORA-30190: reserved for future use

1 Answers  


TNS-00283: Listening on the following TNS addresses:

1 Answers  


Categories