bind variables passed to a program unit
|
32768
|
exception handlers in a program unit
|
65536
|
fields in a record
|
65536
|
levels of block nesting
|
255
|
levels of record nesting
|
32
|
levels of subquery nesting
|
254
|
levels of label nesting
|
98
|
levels of nested collections
|
no predefined limit
|
magnitude of a PLS_INTEGER or BINARY_INTEGER value
|
-2147483648..2147483647
|
number of formal parameters in an explicit
cursor, function, or procedure
|
65536
|
objects referenced by a program unit
|
65536
|
precision of a FLOAT value
(binary digits)
|
126
|
precision of a NUMBER value (decimal digits)
|
38
|
precision of a REAL value
(binary digits)
|
63
|
size of an identifier (characters)
|
30
|
size of a string literal (bytes)
|
32767
|
size of a CHAR value
(bytes)
|
32767
|
size of a LONG value
(bytes)
|
32760
|
size of a LONG RAW value
(bytes)
|
32760
|
size of a RAW value
(bytes)
|
32767
|
size of a VARCHAR2 value (bytes)
|
32767
|
size of an NCHAR value
(bytes)
|
32767
|
size of an NVARCHAR2 value (bytes)
|
32767
|
size of a BFILE value
(bytes)
|
4G * value of DB_BLOCK_SIZE parameter
|
size of a BLOB value
(bytes)
|
4G * value of DB_BLOCK_SIZE parameter
|
size of a CLOB value
(bytes)
|
4G * value of DB_BLOCK_SIZE parameter
|
size of an NCLOB value
(bytes)
|
4G * value of DB_BLOCK_SIZE parameter
|
size of a trigger
|
32 K
|