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 -> Foolish question regarding ref cursors

Foolish question regarding ref cursors

From: Richard S. Crawford <rscrawfordDUCK_at_mossREMOVEWATERFOWLroot.com>
Date: Wed, 10 Mar 2004 11:33:08 -0800
Message-ID: <c2nqi9$kog$1@woodrow.ucdavis.edu>


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

Original text of this message

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