FirebirdSQL logo
 Data Manipulation (DML) StatementsBuilt-in Scalar Functions 

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.

CLOSE Examples

See [fblangref50-psql-fetch-exmpl]

See also

[fblangref50-psql-declare-cursor], [fblangref50-psql-open], [fblangref50-psql-fetch]