Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> v$open_cursors
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
![]() |
![]() |