PLS-00230: OUT and IN OUT formal parameters may not have
default expressions
- 1 Answers
- 6271 Views
- I also Faced
- E-Mail Answers
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 |
ORA-06123: NETTCP: cannot set KEEPALIVE
ORA-01573: shutting down instance, no further change allowed
NPL-00101: uninitialized ASN.1 context
ORA-02077: selects of long columns must be from co-located tables
QSM-02032: no joins are present in the WHERE clause
ORA-12158: TNS:could not initialize parameter subsystem
ORA-08205: ora_addr: $ORACLE_SID not set in environment
ORA-02239: there are objects which reference this sequence
ORA-29299: Invalid handle for piecewise compress or uncompress
DRG-11719: Broader Term hierarchy too deep
QSM-01022: a more optimal materialized view than string was used to rewrite
ORA-30364: this level has the same set of columns as another
Oracle Errors 
