PLS-00214: BEGIN...END block nesting is too deep



PLS-00214: BEGIN...END block nesting is too deep..

Answer / guest

Cause: The number of levels of nesting in the PL/SQL block
is too large. Blocks can be nested up to 255 levels deep,
depending on the availability of system resources such as
memory.

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

RMAN-06193: connected to target database (not started)

3 Answers  


ORA-12412: policy package string is not installed

1 Answers  


ORA-32504: expecting one of string, string, string, or string but found string

1 Answers  


ORA-25193: cannot use COMPRESS option for a single column key

1 Answers  


ORA-01678: parameter string must be pairs of pattern and replacement strings

1 Answers  






ORA-07613: $GETJPIW failed in retrieving the user's process label

1 Answers  


NNL-00301: Server shutting down

1 Answers  


ORA-02177: Missing required group number

1 Answers  


ORA-23333: column string is already part of a column group

1 Answers  


ORA-19334: Invalid column specification for CREATE_DBURI operator

1 Answers  


ORA-26687: no instantiation SCN provided for "string"."string" in source database "string"

1 Answers  


TNS-12531: TNS:cannot allocate memory

1 Answers  


Categories