Stored procedures are collections of SQL statements that are compiled and stored in a database. You can use stored procedures to improve the performance of your application or extend its power by performing tasks that may be beyond the capability of the Dexterity development system.
Stored procedures can receive in parameters, perform server-based processing tasks, and return a status code and out parameters to the application. One stored procedure can call another stored procedure. Stored procedures are often used to:
Information about stored procedures is divided into the following sections: