<< CREATE INDEX | FB 2.5 Language Reference | CREATE PROCEDURE >>
<< REVOKE ADMIN OPTION | FB 2.1 Language Reference | CREATE PROCEDURE >>

Procedure

A stored procedure (SP) is a code module that can be called by the client, by another stored procedure or by a trigger. Stored procedures and triggers are written in Procedural SQL. Most SQL statements are also available in PSQL, sometimes with restrictions or extensions. Notable exceptions are DDL and transaction control statements.

Stored procedures can accept and return multiple parameters.