skip to main content
OpenEdge Data Management: DataServer for ODBC
Stored Procedure Reference : PROC-HANDLE function
 

PROC-HANDLE function

Returns the appropriate return value data type (usually integer) that acts as a unique identifier for an ODBC 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 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 application.

See also

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