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
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
NOTES
- Progress Software 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 Progress application. The DataServer passes SQL statements to the ORACLE RDBMS and uses the default system handle in the process.
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 |