Re: Foolish question regarding ref cursors

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.

-- 
Galen Boyer