Re: how to close an open cursor

From: Ryan <rgaffuri_at_cox.net>
Date: Tue, 31 Dec 2002 00:09:16 GMT
Message-ID: <Me5Q9.96306$pe.3575508@news2.east.cox.net>

please disregard. Stupid question. I wrote this last week and forgot what I was doing. It was a stupid typo. I put my open cursor statement inside my loop.

sorry to bother you guys.

"damorgan" <damorgan_at_exesolutions.com> wrote in message news:3E10CC7A.BFC6E936_at_exesolutions.com...
> Ryan Gaffuri wrote:
>
> > I got careless and had an infinite loop. Killed my session. Now my
> > cursor is still open.
> >
> > I dont have a handler too it. How do I close it without rebooting the
> > system?
>
> What operating system?
> What Oracle version?
> What Oracle edition?
> What privileges do you have in the operating system?
> What privileges do you have in Oracle?
>
> What kind of answer do you expect when you supply no information?
>
> Daniel Morgan
>
Received on Mon Dec 30 2002 - 18:09:16 CST