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 <span>ProcedureName</span>; |
|
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).
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 ; |