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-24043: destination string uses a reserved name, names with AQ$_ prefix are not valid

1 Answers  


ORA-09701: scnfy: maximum number of processes exceeded

1 Answers  


SQL*Loader-00705: Internal error

1 Answers  


RMAN-06476: channel number out of range (1-254): number

1 Answers  


PLS-00540: object not supported in this context.

1 Answers  






NNO-00123: node "string" has no authoritative parent, data ignored

1 Answers  


NNL-00835: Average delete processing time: string

1 Answers  


ORA-32842: value for property string cannot be altered

1 Answers  


ORA-28041: Authentication protocol internal error

1 Answers  


EXP-00013: respond with either 'Y', 'N', RETURN or '.' to quit

1 Answers  


SQL-02157: Source or destination lob is invalid

1 Answers  


PCC-00102: FOR UPDATE is an Oracle extension

1 Answers  


Categories