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.