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-31047: Could not retrieve resource data at path string

1 Answers  


ORA-16628: The broker protection mode is inconsistent with the database setting.

1 Answers  


ORA-25456: rule set was modified or evaluation terminated for iterator: string

1 Answers  


PLS-00382: expression is of wrong type

1 Answers  


ORA-12997: cannot drop primary key column from an index-organized table

1 Answers  


PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types

1 Answers  


TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

1 Answers  


NID-00506: SETNAME Set a new database name only NO

1 Answers  


NZE-29162: Non-FIPS cipher suites being used in FIPS mode.

1 Answers  


ORA-22868: table with LOBs contains segments in different tablespaces

1 Answers  


ORA-00479: RVWR process terminated with error string

1 Answers  


PROT-00707: Cluster registry integrity check failed

1 Answers  


Categories