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-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load

1 Answers  


TNS-04069: Sleeping for number seconds...

1 Answers  


SQL*Loader-00525: OCI return status: success

1 Answers  


ORA-25297: The message options only make sense for buffered messages

1 Answers  


ORA-09344: spsig: error signalling thread

1 Answers  


ORA-12207: TNS:unable to perform navigation

1 Answers  


DRG-11211: charset column must be a char, varchar, or varchar2 type

1 Answers  


ORA-14625: subpartition contains rows corresponding to values being dropped

1 Answers  


LFI-00115: Buffer free failed.

1 Answers  


ORA-13607: The specified task or object string already exists

1 Answers  


ORA-23480: Column string is not a top-level column of "string"."string".

1 Answers  


PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

1 Answers  


Categories