Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
RDBMS Stored Procedure Details : Run Stored-Procedure details : Run Stored-Procedure statement : PROC-HANDLE phrase
 
PROC-HANDLE phrase
The PROC-HANDLE phrase allows you to specify a handle to act as a unique identifier for a MS SQL 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 MS SQL Server.
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.