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.