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-01930: auditing the object is not supported

1 Answers  


TNS-02020: set displaymode RAW | COMPAT | NORMAL | VERBOSE: output mode for lsnrctl display

1 Answers  


SQL*Loader-00808: error creating sequence: string

1 Answers  


SQL*Loader-00456: end of collection found after number elements when looking for number elements

1 Answers  


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  






RMAN-20202: tablespace not found in the recovery catalog

1 Answers  


ORA-26006: Incorrect bind variable in column string's sql expression - string

1 Answers  


ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

1 Answers  


RMAN-06726: could not locate archivelog string

1 Answers  


ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP

1 Answers  


ORA-13338: failure in reversing LRS polygon/collection geometry

1 Answers  


ORA-10632: Invalid rowid

1 Answers  


Categories