Closing cursors after leaving them open.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 23 Jan 2002 22:12:07 -0600
Message-ID: <ubsfkz0dw.fsf@rcn.com>

When I open but don't close a cursor in pl/sql code, and then I try to open it again, I, of course, get cursor still open.

How do I tell Oracle through sqlplus to close that currently open cursor?

I've tried:

sqlplus> close c1;

sqlplus> close cursor c1;

sqlplus> declare
sqlplus> cursor c1 as blah;
sqlplus> begin
sqlplus> close c1;
sqlplus> end;
sqlplus> /

sqlplus> begin
sqlplus> close c1;

sqlplus> end;
sqlplus> /

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Wed Jan 23 2002 - 22:12:07 CST