Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-07643: smsalo: SMSVAR is invalid

1 Answers  


LSX-00134: attribute "~1S" has invalid qualification "~2S"

1 Answers  


NNO-00252: invalid administrative region parameter string value "string"

1 Answers  


ORA-16713: The resource guard timed out while servicing the request.

1 Answers  


QSM-00710: data access error in module string

1 Answers  






ORA-26522: rpc execution error

1 Answers  


PCC-02377: Arrays of implicit varchars are not permitted

1 Answers  


ORA-28559: FDS_CLASS_NAME is string, FDS_INST_NAME is string

1 Answers  


ORA-02854: Invalid number of request buffers

1 Answers  


RMAN-06195: auxiliary database not started

1 Answers  


PLS-00206: %%TYPE must be applied to a variable, column, field or attribute, not to "string"

1 Answers  


ORA-19635: input and output filenames are identical: string

1 Answers  






Categories