EXECUTE

Description

Executes the previously declared procedure identified by
ProcedureName.

Syntax

EXECUTE ProcedureName;

1	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.

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

Examples

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 2022

PB Docs 2022 Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?

Connection Information