EXECUTE

Description

Executes the previously declared procedure identified by ProcedureName.

Syntax

EXECUTE ProcedureName;

Parameter

Description

ProcedureName

The name assigned in the DECLARE statement of the stored procedure you want to execute. The procedure must have been declared previously. ProcedureName is not necessarily the name of the procedure stored in the database.

Usage

The USING TransactionObject clause is not allowed with EXECUTE; the transaction object was specified in the statement that declared the procedure.

NoteError handling It is good practice to test the success/failure code after executing an EXECUTE statement.

Examples

Example 1

This statement executes the stored procedure Emp_proc:

EXECUTE Emp_proc ;