CLOSE Cursor

Close a cursor in a stored procedure.

Syntax

CLOSE cursor_name

Description

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.

Parameters

cursor_name

The name that was associated with the cursor using DECLARE.