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

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