PLS-00228: Illegal declaration of variable of type LONG



PLS-00228: Illegal declaration of variable of type LONG..

Answer / guest

Cause: The identifier is a formal parameter which is being
used in the context of a default expression value for a
formal parameter in the same formal parameter list. E.g.:
procedure p(j number, k number := j).

Action: Remove the offending variable definition

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-21503: program terminated by fatal error

1 Answers  


ORA-16621: Database name for ADD DATABASE must be unique.

1 Answers  


ORA-25292: Cannot add buffer on the specified queue

1 Answers  


ORA-24362: improper use of the character count flag

1 Answers  


TNS-00559: load of Entrust certificate failed

1 Answers  






RMAN-03090: Starting string at string

1 Answers  


ORA-31653: unable to determine job operation for privilege check

1 Answers  


ORA-00324: log file 'string' translated name 'string' too long, string characters exceeds string limit

1 Answers  


RMAN-08132: WARNING: cannot refresh aged file list

2 Answers  


ORA-07508: scgfal: $deq all unexpected return

1 Answers  


RMAN-06903: backup of datafile string was cancelled

1 Answers  


ORA-19922: there is no parent row with id string and level string

1 Answers  


Categories