FirebirdSQL logo

CLOSE

Closes a declared cursor

Syntax
CLOSE cursor_name;
Table 1. CLOSE Statement Parameter
Argument Description

cursor_name

Cursor name.A cursor with this name must be previously declared with a DECLARE …​ CURSOR statement and opened by an OPEN statement

A CLOSE statement closes an open cursor.Only a cursor that was declared with [fblangref50-psql-declare-cursor] can be closed with a CLOSE statement.Any cursors that are still open will be automatically closed after the module code completes execution.