close

SQL/PL

Close an open cursor

Syntax

close_stmt:
          CLOSE  cursor_name

Description

The CLOSE statement is used to close an open cursor.

Example

declare gr_than_avg cursor for select * from acctmgr;    ...    open gr_than_avg;    get_next1: loop       fetch gr_than_avg into l_id, l_name, l_date, l_comm;       if not found then           leave get_next1;       end if;       if l_date >= lo_date and l_date <= hi_date then            set comm_sum = comm_sum + l_comm;           set comm_count = comm_count + 1;       end if;    end loop get_next1;    close gr_than_avg;