Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> v$open_cursors

v$open_cursors

From: Patrick Blalock <Patrick.Blalock_at_cplc.com>
Date: 1997/08/01
Message-ID: <01bc9e6f$de1221e0$1e02030a@pc004044>#1/1

I have a PL/SQL procedure which explicitly opens and then closes two cursors; however, after the procedure executes the view v$open_cursors still lists the two cursors.

Does anyone know why the cursors are still in the v$open_cursors view after I have issued an explicit close on the cursor?

Thanks in advance,

Patrick Received on Fri Aug 01 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US