Progress
DataServer
for ORACLE Guide
CLOSE STORED-PROCEDURE Statement
Retrieves the output parameter values from an ORACLE stored procedure and indicates that the procedure is finished.
SYNTAX
procedure
The name of the stored procedure that you want to close.
integer-field = PROC-STATUS
The PROC-STATUS function returns the value of the return value from the ORACLE stored procedure.
WHERE PROC-HANDLE = integer-field
An integer whose value uniquely identifies the stored procedure that produces the results returning from the ORACLE database.
EXAMPLEThe PROC-STATUS clause of the CLOSE STORED-PROCEDURE statement allows the DataServer for ORACLE to retrieve the text of an ORACLE error message that was passed to raise_application_error. Use the ERROR-STATUS:GET-MESSAGE handle to retrieve the message as in the following example:
NOTES
EXAMPLE
- If you specified a PROC-HANDLE when you ran a stored procedure, you must specify the PROC-HANDLE when you close the stored procedure.
- If you do not specify a PROC-HANDLE, the CLOSE STORED-PROC statement will close the procedure if there is only one stored procedure running. If there is more than one stored procedure running, an error will be returned.
- You can close all stored procedures at once with the following statement:
- You cannot close a send-sql-statement procedure until you have retrieved all row results.
The PROC-STATUS clause of the CLOSE STORED-PROCEDURE statement allows the DataServer to retrieve the text of an ORACLE error message that was passed to raise_application_error. Use the ERROR-STATUS:GET-MESSAGE handle to retrieve the message as in the following example:
SEE ALSO
PROC-HANDLE Function, PROC-STATUS Function, RUN STORED-PROCEDURE Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |