For a non-Progress stored procedure, PROC-STATUS indicates that the procedure has completed execution and retrieves any return status. For a send-sql-statement stored procedure, CLOSE STORED-PROCEDURE closes the SQL cursor used by the procedure, as shown:
CLOSE STORED-PROCEDURE procedure-name [integer-field = PROC-STATUS ] [ WHERE PROC-HANDLE = integer-field]
procedure-name
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.
Consider these points concerning the CLOSED STORED-PROCEDURE statement:
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-PROCEDURE statement closes the procedure if there is only one stored procedure running. If there is more than one stored procedure running, an error is returned.
If you specified a PROC-HANDLE when you ran a stored procedure, you must specify the PROC-HANDLE when you close the stored procedure.