Yeah, lots change with Oracle between 5 and MX -- especially the fact that you don't need to reference REFCURSORs with CFPROCPARAMs anymore; you just directly reference them in CFPROCRESULTs in MX.
I really would like to see named notation work with stored procedures in ColdFusion. They're very flexible. I haven't tried overloading an Oracle package as a workaround yet. Have you? Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 25, 2002 11:24 AM Subject: CFPROCPARAM behavior change with MX+Oracle? > Hey all, > > I'm wondering if anybody else has noticed that CFStoredProc and > CFProcParam behavior has changed (with Oracle) from Pre-MX to MX with > respect to 'Named Notation' no longer working for Oracle in MX? Or was > everybody just smart and have their CFProcParams in the right order > before? > > In Pre-MX, you didn't have to have your CFProcParams in the same order > as the SP (in Oracle). > > In MX, you do - which is consistant with Oracle JDBC. > > Or am I crazy... > -- > Edward Smith Internet Broadcasting System > Director of Architecture http://www.ibsys.com > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
