•
|
SET CACHED_PROCEDURES – specifies the number of procedures to cache. The default is 50.
|
•
|
SET PROCEDURES_CACHE – specifies the amount of memory for the cache. The default is 5 MB.
|
•
|
•
|
•
|
The stored procedure contains an EXEC[UTE] statement used to execute a character string, or an expression that returns a character string. For example: EXEC ('SELECT Student_ID FROM ' + :myinputvar).
|
•
|
See Table 1, Identifier Restrictions by Identifier Type in Advanced Operations Guide for the maximum length of a stored procedure name.
|
•
|
There is currently no support for using subqueries everywhere expressions are used. For example an UPDATE statement with set :arg = SELECT MIN(sal) FROM emp is not supported. However, you could rewrite the subquery as SELECT min(sal) INTO :arg FROM emp.
|