Re: Open Cursor

From: Jurij Modic <jmodic_at_src.si>
Date: Sat, 09 Jan 1999 22:18:45 GMT
Message-ID: <3697c848.6198343@news.siol.net>

On Sat, 09 Jan 1999 07:51:55 +0100, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>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.

I've noticed in my Personal Oracle 7.3.2 that instance closes implicit cursors for a session after any DDL commands are performed from inside this session.

>Hth,
>Sybrand Bakker, Oracle DBA

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Jan 09 1999 - 16:18:45 CST