Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Closing Cursors
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