Progress
Language Reference


CLOSE STORED-PROCEDURE Statement

Interfaces
OS
SpeedScript
All
All
Yes

For a non-Progress stored procedure, indicates that the procedure has completed execution and retrieves any return status. For a send-sql-statement stored procedure, closes the SQL cursor used by the procedure.

SYNTAX

CLOSE STORED-PROCEDURE procedure
  [ integer-field = PROC-STATUS ]
  [ WHERE PROC-HANDLE = integer-field ] 

procedure

The name of the stored procedure that you want to close or the built-in procedure name, send-sql-statement.

integer-field = PROC-STATUS

Assigns the return value from a stored procedure to the specified integer field or variable (integer-field).

WHERE PROC-HANDLE = integer-field

An integer field or variable whose value uniquely identifies the stored procedure that produces the results returned from the data source or the SQL cursor of a send-sql-statement stored procedure.

EXAMPLE

The 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:

DEFINE VARIABLE st AS INTEGER INITIAL 0.
DEFINE VARIABLE h  AS INTEGER. 

RUN STORED-PROC p1 h = PROC-HANDLE NO-ERROR. 

CLOSE STORED-PROC p1 st = PROC-STATUS WHERE PROC-HANDLE = h.  

DISPLAY st. 

IF ERROR-STATUS:ERROR 
     THEN
   MESSAGE ERROR-STATUS:GET-MESSAGE(1) ERROR-STATUS:GET-NUMBER(1)
          VIEW-AS ALERT-BOX.  

NOTES

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