Stored Procedures

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:

• Move complex processing tasks from the client to the server.
• Streamline your code, since the same stored procedure can be used by different parts of your application or multiple applications.

Information about stored procedures is divided into the following sections:

• Using stored procedures
• Creating a prototype procedure
• Stored procedure parameters
• Pathname support for stored procedures
• Stored procedure time limits

Documentation Feedback

---