REEXEC_ORACLE_STORED_PROCEDURE¶

Applies to: ORAFlex

This command is used to re-execute a stored procedure when using Oracle. Although it follows the same format as CALL_STORED_PROCEDURE, it can be useful because it does not need to prepare the procedure again before executing. This can cause speed improvements when calling a stored procedure multiple times.

Syntax

CALL_ORACLE_STORED_PROCEDURE {procedure} Passing {variable}

Parameter	Description
procedure	Full name of the procedure
variable	Parameter to pass (optional and can be multiple)

Example

CALL_STORED_PROCEDURE "user.getCustomerStatus" Passing sCustomerID sStatus
Showln sStatus

Move (sCustomerID + 1) to sCustomerID

REEXEC_ORACLE_STORED_PROCEDURE "user.getCustomerStatus" passing sCustomerID sStatus
Showln sStatus

CALL_STORED_PROCEDURE