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

NNO-00331: error saving new value string of string to the save config table.

1 Answers  


ORA-36770: (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed

1 Answers  


ORA-14261: partition bound may not be specified when adding this Hash partition

1 Answers  


ORA-08210: Requested I/O error

1 Answers  


TNS-04064: The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.

1 Answers  






TNS-00526: No caller (false async event)

1 Answers  


ORA-02054: transaction string in-doubt

1 Answers  


ORA-32830: result code string returned by Messaging Gateway agent

1 Answers  


KUP-04076: file name cannot contain a path specification: string

1 Answers  


DRG-11850: Transformation Applied

1 Answers  


LPX-00657: Invalid output PI '~S'.

1 Answers  


ORA-24381: error(s) in array DML

1 Answers  


Categories