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

PLS-00637: FINAL method cannot be overriden or hidden

1 Answers  


NNC-00003: error opening stream string

1 Answers  


SQL*Loader-00953: Error shipping read buffer across 2-task

1 Answers  


RMAN-06580: the string option cannot be used with AS COPY

1 Answers  


NCR-04009: NCRR: Object exists

1 Answers  






SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used

1 Answers  


NNL-00262: Request forwarding is currently disabled

1 Answers  


TNS-00073: * stop/abort - stop the process_name

1 Answers  


ORA-30086: interval year-month result not allowed for datetime subtraction

1 Answers  


ORA-39313: illegal clone() call: clone has been done before

1 Answers  


TNS-01060: The password has has been set to: string

1 Answers  


LRM-00112: multiple values not allowed for parameter 'string'

1 Answers  


Categories