Progress
DataServer for
Microsoft SQL Server
Guide


CLOSE STORED–PROCEDURE Statement

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.

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.

NOTES

RUN STORED-PROC closeallprocs. 

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