Re: Open Cursor

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 09 Jan 1999 07:51:55 +0100
Message-ID: <3696FC8B.CF75ECBA@sybrandb.demon.nl>

Hi Mr. Pillai
As far as I have seen in Oracle 7 no implicit cursors are being released whether in sqlplus or in pl/sql. This is why always advise people in pl/sql programs to avoid implicit cursors. As sqlplus is dynamically/interpreted sql only, I don't believe much can be done about this situation.

Hth,

Sybrand Bakker, Oracle DBA

pjpillai_at_my-dejanews.com wrote:

> I am working with Oracle 8.0.5. When I submit a query from SQLPLUS, oracle
> server opens an implicit cursor and can seen in v$open_cursor view.
>
> If I submit different query Oracle server open another cursor.
>
> Now all these cursors will be open until I close my SQLPLUS session.
>
> My questions is whether this is correct behaviour or defination by itself ?
>
> Thanks in advance.
>
> P J Pillai.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Sat Jan 09 1999 - 00:51:55 CST