Using Executable Procedures
Go Up to Working with Stored Procedures
An executable procedure is called directly by an application, and often performs a task common to applications using the same database. Executable procedures can receive input parameters from the calling program, and can optionally return a single row to the calling program.
Input parameters pass to an executable procedure in a comma-delimited list following the procedure name.
- Note: Executable procedures cannot return multiple rows.