Progress
DataServer
for ODBC Guide


CLOSE STORED–PROCEDURE Statement

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.

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