•
|
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).
|
•
|
Triggers (CREATE TRIGGER, DROP TRIGGER) are supported as a form of stored procedure. This support includes tracking dependencies that the trigger has on tables, and procedures, in the database. You cannot use CREATE PROCEDURE or CREATE TRIGGER in the body of a stored procedure or a trigger.
|
•
|
•
|
LOOP: post conditional loops are not supported (REPEAT...UNTIL).
|
•
|
•
|
•
|
See Table 1, Identifier Restrictions by Identifier Type in Advanced Operations Guide for the maximum length of a stored procedure name.
|
•
|
Only partial syntactical validation occurs at CREATE PROCEDURE or CREATE TRIGGER time. Column names are not validated until run time.
|
•
|
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.
|
•
|
Positioned UPDATE does not accept a table name.
|