Executes the previously declared procedure identified by ProcedureName.
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. |
The USING TransactionObject clause is not allowed with EXECUTE; the transaction object was specified in the statement that declared the procedure.
Error handling It is good practice to test the success/failure code after executing an EXECUTE statement.
This statement executes the stored procedure Emp_proc:
EXECUTE Emp_proc ;