Re: Foolish question regarding ref cursors

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 12 Mar 2004 10:10:12 -0600
Message-ID: <ullm6cakc.fsf@standardandpoors.com>

On Thu, 11 Mar 2004, rscrawfordDUCK_at_mossREMOVEWATERFOWLroot.com wrote:

> Galen Boyer wrote:
> 

>> On Wed, 10 Mar 2004,
>> rscrawfordDUCK_at_mossREMOVEWATERFOWLroot.com wrote:
>>
>>>I have a Cold Fusion page which calls an Oracle Stored
>>>Procedure, which in turn returns a ref cursor containing a
>>>result set. I've discovered that if I close the cursor before
>>>returning to Cold Fusion, then Cold Fusion does not have
>>>access to the result set.
>> Not sure why you thought differently.
>>
>>>My question is, is it prudent to call another stored procedure
>>>after Cold Fusion has the result set that will close the ref
>>>cursor? Or is it okay to just leave it open?
>> You need to iterate over the result set doing whatever you
>> need to do and then close it.
>>

> 
> I'm not really doing anything with the result set in the stored
> procedure.  The job of the stored procedure is to pull up a
> result set which it passes back to Cold Fusion.  

But you are doing something with the stored procedure. You are using its results to load up memory within cold fusion. You have to explicitly retrieve those results. They don't just somehow transfer themselves to Cold Fusion.

After retrieval, then close.

-- 
Galen Boyer

Received on Fri Mar 12 2004 - 10:10:12 CST