Progress
DataServer
for ORACLE Guide


PROC-HANDLE Function

Returns the appropriate return value data type (usually integer) that acts as a unique identifier for an ORACLE stored procedure:

SYNTAX

PROC-HANDLE 

This procedure runs the ORACLE stored procedure pcust and writes the procedure handle to the variable handle. It writes the results of the stored procedure identified by this procedure handle into the Progress-supplied buffer, proc-text-buffer, and displays it:

EXAMPLE

DEFINE VAR h1 AS INTEGER.

RUN STORED-PROC pcust h1 = PROC-HANDLE 
(10, OUTPUT 0, OUTPUT 0).
FOR EACH proc-text-buffer WHERE PROC-HANDLE = h1:
  DISPLAY proc-text.
END.
CLOSE STORED-PROC pcust WHERE PROC-HANDLE = h1. 

NOTES

SEE ALSO

CLOSE STORED-PROCEDURE Statement, PROC-STATUS Function, RUN STORED-PROCEDURE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095