Try OpenEdge Now
skip to main content
DataServer for Oracle
RDBMS Stored Procedure Details : RUN STORED-PROCEDURE details : RUN STORED-PROCEDURE statement : PROC-HANDLE phrase
The PROC-HANDLE phrase allows you to specify a handle to act as a unique identifier for an Oracle DataServer stored procedure. For example, the PROC-HANDLE assigns a value to the specified integer field or variable (integer-field) that uniquely identifies the:
*Stored procedure that is returning results from Oracle
*SQL cursor that is used to retrieve results from an Oracle Server data source
Note these additional points about the PROC-HANDLE:
*Progress Software Corporation recommends that you specify a procedure handle for each stored procedure that you run.
*You do not have to specify a handle if there is only one active stored procedure and you do not include SQL statements in the OpenEdge application.