Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00438: value in LIMIT clause: 'string' use is invalid

1 Answers  


TNS-12165: TNS:Trying to write trace file into swap space.

1 Answers  


ORA-09772: osnpmetbrkmsg: message from host had incorrect message type

1 Answers  


QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-16013: log string sequence# string does not need archiving

1 Answers  






NZE-28835: Identity descriptor is not present or is too small.

1 Answers  


ORA-29280: invalid directory path

1 Answers  


O2U-00205: None of the characters in a type name were legal identifier characters

1 Answers  


ORA-16744: The DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full.

1 Answers  


RMAN-06213: --------------- ---------------------------------------------------

1 Answers  


DRG-12431: configuration section string not found

1 Answers  


QSM-02014: GROUP BY expression other than a column

1 Answers  






Categories