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 -> Re: Closing Cursors

Re: Closing Cursors

From: K Stahl <BlueSax_at_Unforgettable.com>
Date: Fri, 11 Feb 2000 14:43:50 -0500
Message-ID: <38A46676.6EAFA4B3@Unforgettable.com>


Peter L wrote:
>
> On Fri, 11 Feb 2000 13:42:06 -0500, K Stahl
> <BlueSax_at_Unforgettable.com> wrote:
>
> >Peter L wrote:
> >>
> >> I seem to remember reading in this newsgroup about a parameter that
> >> had to set to make sure that Oracle really closed cursors when you
> >> told it to. The default action was to leave them open in case you
> >> needed them again.
> >>
> >> Can anyoen supply details of this or have I dreamt it?
> >
> >If you are talking about Pro-C then what you need are the parameters
> >RELEASE_CURSOR=YES and HOLD_CURSOR=NO
> >
> Is this just a Pro C problem? Can we just forget about it if we are
> using PL/SQL?

It really shouldn't cause any problems in PL/SQL. Can you describe a scenario where you think it would make a difference? Received on Fri Feb 11 2000 - 13:43:50 CST

Original text of this message

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