Progress
Language Reference
PROC-HANDLE Function
Returns a value in the appropriate data type (usually INTEGER) that is a unique identifier for a stored procedure.
SYNTAX
EXAMPLE
This procedure runs the 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.
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. In the case of ORACLE only, the DataServer passes SQL statements to the ORACLE RDBMS and uses the default system handle in the process.
- For more information on using this function, see the Progress DataServer Guides , Progress DataServer for ODBC Guide and Progress DataServer for ORACLE Guide.
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 |