1.9.1 Procedures

Procedures are defined in a CREATE PROCEDURE or CREATE TYPE procedure.

Procedures can be divided into the following categories depending on the language in which the routines are written:

Note that although trigger action procedures created in a trigger definition are also a part of SQL procedures, they are defined in CREATE TRIGGER as a schema element (a trigger) separate from a routine. Trigger action procedures, which are automatically executed upon a specified trigger event, cannot perform calls using a CALL statement or pass values using an SQL parameter.