Creating Triggers and Stored Procedures
Go Up to Procedures and Triggers
Stored procedures and triggers are defined with the
CREATE PROCEDURE and
CREATE TRIGGER statements, respectively. Each of these statements is composed of a header and a body.
The header contains::
- The name of the procedure or trigger, unique within the database.
- For a trigger:
- A table name, identifying the table that causes the trigger to fire.
- Statements that determine when the trigger fires.
- For a stored procedure:
- An optional list of input parameters and their data types.
- If the procedure returns values to the calling program, a list of output parameters and their data types.
The body contains: :
- An optional list of local variables and their data types.
- A block of statements in InterBase procedure and trigger language, bracketed by
END. A block can itself include other blocks, so that there may be many levels of nesting.