Get rid of the CFPROCPARAM that refers to your REFCURSOR. You don't need it any more in MX; just refer directly to the resultset with CFPROCRESULT as you are already doing.
I just finished writing about this change in Oracle behavior in an upcoming ColdFusion MX book. 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: "freddy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 10:32 AM Subject: ORACLE refcursors in CFMX > What syntax do I use in cfmx to retrieve oracle ref cursors as cf > recordsets? > The following is what I used in CF5 but it doesn't work in MX: > > <cfstoredproc datasource="#SID#" > procedure="AKC.pkg_store_util.pr_sub_category_list" > returncode="no"> > <cfprocparam > dbvarname="in_cde_category" > cfsqltype="cf_sql_varchar" > value="#request.category_cde#" > type="in"> > <cfprocparam > dbvarname="out_sub_category_list" > variable="out_sub_category_list" > cfsqltype="cf_sql_refcursor" > maxrows=-1 > type="out"> > <cfprocparam > dbvarname="out_desc_category" > variable="desc_category" > cfsqltype="cf_sql_varchar" > type="out"> > <cfprocresult name="sub_category_list" resultset="1"> > </cfstoredproc> > > Thanks, > > Frederic > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
