This section describes the SQL form of stored procedures.
- Granting Privileges on Stored Procedures
- Checking Privileges for Stored Procedures
- Rules for Using SQL Statements in Stored Procedures
- Running a Stored Procedure
- Recompiling a Stored Procedure
- Restrictions on Stored Procedures
- Stored Procedure Lexicon
- DDL Statements in Stored Procedures
- DML Statements in Stored Procedures
- DCL Statements in Stored Procedures
- Diagnostics Statements in Stored Procedures
- SQL Operations on Stored Procedures
- Control Statements in Stored Procedures
- Completion, Exception, and User-defined Condition Handlers
- Cursor Declarations
- Using Dynamic SQL in Stored Procedures
- Recursive Stored Procedures
- Stored Procedures and Tactical Queries
- Debugging Stored Procedures
- Sample Stored Procedure