Rules for SPL Routines

In addition to the rules listed in Re-Entrancy of Triggers, the following rules apply to an SPL routine that is specified as a trigger action:

• The SPL routine cannot be a cursor function (one that returns more than one row) in a context where only one row is expected.
• You cannot use the old or new correlation name inside the SPL routine. If you need to use the corresponding values in the routine, you must pass them as parameters. The routine should be independent of triggers, and the old or new correlation name does not have any meaning outside the trigger.

When you use an SPL routine as a trigger action, the database objects that the routine references are not checked until the routine is executed.

See also the SPL restrictions in Triggers and SPL Routines.