CLOSE
Procedure
SQL statement
Description
Closes the SQL procedure ProcedureName; ends processing of
ProcedureName.
DBMS-specific
Not all DBMSs support stored procedures.
Syntax
|
1 |
CLOSE ProcedureName; |
|
Parameter |
Description |
|---|---|
|
ProcedureName |
The stored procedure you want to |
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).
Error handling
It is good practice to test the success/failure code after
executing a CLOSE Procedure statement.
Examples
This statement closes the stored procedure named Emp_proc:
|
1 |
CLOSE Emp_proc ; |