CLOSE Procedure

Description

Closes the SQL procedure ProcedureName; ends processing of ProcedureName.

NoteDBMS-specific Not all DBMSs support stored procedures.

Syntax

CLOSE ProcedureName;

Parameter

Description

ProcedureName

The stored procedure you want to close

Usage

This statement must be preceded by an EXECUTE statement for the same procedure. The USING TransactionObject clause is not allowed with CLOSE; the transaction object was specified in the statement that declared the procedure.

Use CLOSE only to close procedures that return result sets. PowerBuilder automatically closes procedures that do not return result sets (and sets the return code to 100).

CLOSE often appears in the script that is executed when the SQL code after a fetch equals 100 (not found).

NoteError handling It is good practice to test the success/failure code after executing a CLOSE Procedure statement.

Examples

Example 1

This statement closes the stored procedure named Emp_proc:

CLOSE Emp_proc ;