Here's my $0.02.. I had to debug an app that uses MS SQL Server stored procs via <cfstoredproc> in many places. It was working in development testing, and started failing after deployment.
Named notation with "optional/default" values for certain parameters was used. The app actually works with named notation UNLESS: there exists a datetime parameter between parameter 1 and parameter N (where N > 2). Then cfstoredproc reverts to positional notation. If you create a trivial stored proc with just integer and varchar parameters, named notation would work. Test it. :) ---------------------------- James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: Adam Churvis [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 10:23 AM To: CF-Talk Subject: Re: CFPROCPARAM behavior change with MX+Oracle? 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 > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
