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

imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.

1 Answers  


ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  


DRG-10701: preference string.string already exists

1 Answers  


LFI-00005: Free some memory failed in string.

1 Answers  


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  






ORA-00031: session marked for kill

1 Answers  


ORA-13506: operation failed due to invalid snapshot range (string, string)

1 Answers  


ORA-09840: soacon: Name translation failure.

1 Answers  


PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-12465: Not authorized for read or write on specified groups or compartments

1 Answers  


ORA-00129: listener address validation failed 'string'

1 Answers  


ORA-29259: end-of-input reached

1 Answers  


Categories