CLOSE Cursor

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

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