PLS-00230: OUT and IN OUT formal parameters may not have
default expressions
- 1 Answers
- 7183 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-33010: (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
PLS-00423: ORDER BY item must be the number of a SELECT-list expression
ORA-01174: DB_FILES is string buts needs to be string to be compatible
ORA-06561: given statement is not supported by package DBMS_SQL
ORA-08232: smsdes: cannot detach from SGA
ORA-14500: LOCAL option not valid without partition name
SQL*Loader-00953: Error shipping read buffer across 2-task
NZE-29241: a buffer block needs to more space but its length is fixed
NZE-29039: There are no matching cipher suites.
ORA-12042: cannot alter job_queue_processes in single process mode
LRM-00102: 'string' is not in the legal range for 'string'
ORA-22893: constraint can be specified only for REF columns
Oracle Errors 
