Closes the SQL cursor CursorName; ends processing of CursorName.
CLOSE CursorName ;
Parameter |
Description |
---|---|
CursorName |
The cursor you want to close |
This statement must be preceded by an OPEN statement for the same cursor. The USING TransactionObject clause is not allowed with CLOSE; the transaction object was specified in the statement that declared the cursor.
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 cursor statement.
This statement closes the Emp_cursor cursor:
CLOSE Emp_cursor ;