CLOSE
The CLOSE statement in SQL Script is used to close a cursor. See
DECLARE CURSOR of Type Variable for details on declaring cursors.
Syntax
CLOSE <cursor>
Errors
The following table describes the errors that can occur while executing a CLOSE statement.
Error Message | Cause |
Uninitiallized cursor | A cursor variable is used and is not initialized at the time it is opened. |
Cursor is not open | CLOSE was invoked when the cursor was not open. |