PROC-HANDLE function

Returns a value in the appropriate data type (usually INTEGER) that is a unique identifier for a stored procedure.

Syntax 

 

PROC-HANDLE

Example 

This procedure runs the stored procedure pcust and writes the procedure handle to the variable iHandle. It writes the results of the stored procedure identified by this procedure handle into the ABL-supplied buffer, proc-text-buffer, and displays it.

 

DEFINE VARIABLE iHandle AS INTEGER NO-UNDO.   RUN STORED-PROCEDURE pcust iHandle = PROC-HANDLE (10, OUTPUT 0, OUTPUT 0). FOR EACH proc-text-buffer WHERE PROC-HANDLE = iHandle: DISPLAY proc-text. END. CLOSE STORED-PROCEDURE pcust WHERE PROC-HANDLE = iHandle.

Notes 

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 ABL application. In the case of ORACLE only, the DataServer passes SQL statements to the ORACLE RDBMS and uses the default system handle in the process.

For more information on using this function, see the OpenEdge DataServer Guides (OpenEdge Data Management: DataServer for Microsoft SQL Server, OpenEdge Data Management: DataServer for ODBC, and OpenEdge Data Management: DataServer for Oracle).

See also 

CLOSE STORED-PROCEDURE statement, PROC-STATUS function, RUN STORED-PROCEDURE statement