Oracle PL/SQL: PL/SQL compiler nesting limits - The PL/SQL compiler imposes limits for block, record, subquery and label nesting. These limits are a

Quick Search:

Oracle PL/SQL: PL/SQL compiler nesting limits

Jump to:

Category: >> Oracle PL/SQL >> PL/SQL compiler nesting limits

<< last

next >>

Snippet Name: PL/SQL compiler nesting limits

Description: The PL/SQL compiler imposes limits for block, record, subquery and label nesting. These limits are as follows:

Level of Block Nesting: 255
Level of Record Nesting: 32
Level of Subquery Nesting: 254
Level of Label Nesting: 98

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 06th, 2009

-- PL/SQL compiler limits for nesting:
 
-- Level of Block Nesting: 255
-- Level of Record Nesting: 32
-- Level of Subquery Nesting: 254
-- Level of Label Nesting: 98