CLOSE Cursor

Close a cursor in a stored procedure, user defined function or trigger.


CLOSE cursor_name


This closes the cursor. The cursor result set is no longer available in memory. The cursor variable can only be accessed again by opening the cursor. The first FETCH statement positions the cursor back to the first row of the cursor result set.