EXECUTE SQL statement

Executes the previously declared procedure identified by ProcedureName.

EXECUTE <span>ProcedureName</span>;

1	EXECUTE <span>ProcedureName</span>;

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 ;

1	EXECUTE Emp_proc ;

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.5

August 9, 2023

Was this article helpful?

Connection Information