RE: CFPROCPARAM behavior change with MX+Oracle?
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPROCPARAM behavior change with MX+Oracle?
With SQL server you had to specify the proc params in order regardless of CF version. Led me to wonder why you had to specify a dbvarname attribute at all if it didn't appear to be used. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 16:24 To: CF-Talk 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: CFPROCPARAM behavior change with MX+Oracle?
Whenever I have used ORACLE stored procs (and we use ORACLE and SPs eclusively here) with CF version 4, 4.5.1, 5 I have had to specify the params in order or I recieved the wrong number of calls or types error. As far as I know this has always been the situation but I could always be wrong. Frederic [EMAIL PROTECTED] wrote: 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... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
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 __ 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
