| Parameter | Value |
|---|---|
| Maximum number of parameters specified in a macro. | 2,048 |
| Maximum expanded text size for macros and views. | 2 MB |
| Maximum number of open cursors per procedure. | 15 |
| Maximum number of result sets a procedure can return. | 15 |
| Maximum number of columns returned by a dynamic result table function. The valid range is from 1 to 2,048. There is no default. |
2,048 |
| Maximum number of dynamic SQL requests per procedure. | 15 |
| Maximum length of a dynamic SQL request in a procedure. This includes its SQL text, the USING data (if any), and the CLIv2 parcel overhead. |
Approximately 1 MB |
| Maximum combined size of the parameters for a procedure | 1 MB for input parameters 1 MB for output (and input/output) parameters |
| Maximum size of condition names and UDF names specified in a procedure. | 30 bytes |
| Maximum number of parameters specified in a UDF. | 128 |
| Maximum number of parameters that can be defined for a constructor method for all types except ARRAY/VARRAY | 128 |
| Maximum number of combined return values and local variables that can be declared in a single UDF. | Unlimited |
| Maximum number of combined external routine return values and local variables for which instances can be created at the same time per session. | 1,000 |
| Maximum combined size of the parameters defined for a UDF. | 1 MB for input parameters 1 MB for output parameters |
| Maximum number of parameters specified in a method. | 128 |
| Maximum number of parameters specified in an SQL procedure. | 256 |
| Maximum number of parameters specified in an external procedure written in C or C++. | 256 |
| Maximum number of parameters specified in an external procedure written in Java. | 255 |
| Maximum length of external name string for an external routine. An external routine is the portion of a UDF, external procedure, or method that is written in C, C++, or Java (only external procedures can be written in Java). This is the code that defines the semantics for the UDF, procedure, or method. |
1,000 characters |
| Maximum package path length for an external routine. | 256 characters |
| Maximum SQL text size in a procedure. | Approximately 1 MB |
| Maximum number of nested CALL statements in a procedure. | 15 |
| Maximum number of Statement Areas per SQL procedure diagnostics area. See Diagnostics Area . | 1 |
| Maximum number of Condition Areas per SQL procedure diagnostics area. See Diagnostics Area . | 16 |