Foolish question regarding ref cursors

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.

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? Received on Wed Mar 10 2004 - 13:33:08 CST