Closes the SQL procedure ProcedureName; ends processing of ProcedureName.
CLOSE ProcedureName;
Parameter |
Description |
---|---|
ProcedureName |
The stored procedure you want to close |
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.
This statement closes the stored procedure named Emp_proc:
CLOSE Emp_proc ;