PLS-00102: parser stack overflow because nesting is too deep



PLS-00102: parser stack overflow because nesting is too deep..

Answer / guest

Cause: The parser, which checks the syntax of PL/SQL
statements, uses a data structure called a stack; the number
of levels of nesting in the PL/SQL block exceeded the stack
capacity.

Action: Reorganize the block structure to avoid nesting at
too deep a level. For example, move the lowest-level
sub-block to a higher level.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02276: default value type incompatible with column type

1 Answers  


TNS-01067: Service display mode is string

1 Answers  


ORA-07234: slemcw: fseek error.

1 Answers  


ORA-07824: sspain: $SETIMR failure

1 Answers  


RMAN-07521: cannot create recovery catalog in database version string; version string required

1 Answers  






ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string

1 Answers  


NNL-00950: Cache lookup requests: number

1 Answers  


ORA-39039: Schema expression "string" contains no valid schemas.

1 Answers  


TNS-00247: Unable to allocate memory for configuration data from TNSNET.ORA file

1 Answers  


ORA-27507: IPC error disconnecting from a port

1 Answers  


ORA-08448: syntax error in DECIMAL-POINT environment clause

1 Answers  


RMAN-20220: controlfile copy not found in the recovery catalog

1 Answers  


Categories