FirebirdSQL logo
 Data Manipulation (DML) StatementsBuilt-in Scalar Functions 

Stored Procedures

A stored procedure is executable code stored in the database metadata for execution on the server.It can be called by other stored procedures (including itself), functions, triggers and client applications.A procedure that calls itself is known as recursive.

Benefits of Stored Procedures

Stored procedures have the following advantages:

Modularity

applications working with the database can use the same stored procedure, thereby reducing the size of the application code and avoiding code duplication.

Simpler Application Support

when a stored procedure is modified, changes appear immediately to all host applications, without the need to recompile them if the parameters were unchanged.

Enhanced Performance

since stored procedures are executed on a server instead of at the client, network traffic is reduced, which improves performance.