Yes, using REFCURSORs is still the best method, but you no longer have to use a CFPROCPARAM with a MaxRows=-1 to bind the REFCURSOR to the result set and instruct ColdFusion to return all rows referenced by the REFCURSOR.
So in CFMX, simply omit the CFPROCPARAM tags that, in CF5 applications, had CFSQLTYPEs of CF_SQL_REFCURSOR, and keep the CFPROCRESULT tags that enumerated your result sets from those REFCURSORs. Remember that you must be using a JDBC Type 4 Oracle driver for multiple result sets, so either run CFMX Enterprise or install the freebie OIC driver from Oracle in CFMX Professional. I also came up with a way to do compile-time binding of relational result sets to Oracle REFCURSORs, which greatly increases performance. None of the current ColdFusion books show how to do this, but instead opt for compile-time binding of flat result sets (practically useless) or runtime binding of untyped REFCURSORs (unnecessarily slow). I show how to do this in an upcoming ColdFusion MX book I'm writing, but if you need to learn this right away, just contact me offline. Hope this helps. Have a great day! :) Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion Developer Productivity Enhancement, Inc. http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 ----- Original Message ----- From: "Chris Lofback" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 05, 2002 11:51 AM Subject: Record set from Oracle Stored Procedure, correction > I meant, when using a stored procedure... > > Chris Lofback > Sr. Web Developer > > TRX Integration > 28051 US 19 N., Ste. C > Clearwater, FL 33761 > www.trxi.com > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
