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: Peter L <news_at_abc.co.uk>
Date: Fri, 11 Feb 2000 19:28:59 GMT
Message-ID: <38a462c6.4165134@news.freeserve.net>


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? Received on Fri Feb 11 2000 - 13:28:59 CST

Original text of this message

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