From: <>
Date: Wed, 6 Feb 2008 08:49:47 -0800 (PST)
Message-ID: <>

Comments embedded.
On Feb 6, 1:34 am, Guru <> wrote:
> Dear All,
> I want to close all Opened Ref Cursor in my application.

The write some decent code and clean up your mess before you leave the playground, not after.

> For this, How shall i get Opened Ref Cursor Name's using V
> $OPEN_CURSOR? Or Any other way to find opened Ref Cursor names in
> ORACLE 9i?

If this truly is your application, then you need some serious education on how to write one, as leaving open cursors lying about is truly abysmal technique.

> Thanks in Advance,
> Guruprasath B

David Fitzjarrell Received on Wed Feb 06 2008 - 10:49:47 CST

Original text of this message