Open Cursor

From: <pjpillai_at_my-dejanews.com>
Date: Sat, 09 Jan 1999 06:23:40 GMT
Message-ID: <776slb$leu$1@nnrp1.dejanews.com>

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:23:40 CST