Hi Aaron, Mostly resolved.
It turned out that a call using a cfstoredproc to a function in an Oracle package was not passing the correct number of parameters that function was expecting. The function was expecting to be passed 3 parameters and there were only 2 cfprocparam's being passed. The function has default value in placed for the second and third parameter, but for whatever reason, the defaults we're coming into play and the function, Orale, the JDBC driver, or coldfusion threw an error because of it. Passing a valid value in a cfprocparam for the third value appeared to have resolved the issue and allowed all the CF code and the Oracle function to execute without errors. This is really bizzare, as the CF code nor the Orcale Function has not changed in over 6 months. The only thing that has changed was the update of the "macromedia_drivers.jar" file a number of months ago, and the update to ColdFusion 7.0.2. Why would Oracle functions suddenly start demanding all parameters when it has been fine to not have all in place in the past?? Can anyone speculate on the potential of a communications issue between CF/Java and the Oracle database? Cheers, Justin Mundy -----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: June 14, 2007 8:43 PM To: CF-Talk Subject: Re: [Macromedia][Oracle JDBC Driver]Object has been closed. I ran into a very similar problem back in January of this year and could not find a solution at the time. I do not have the best of notes on it but I do have down that at the time I tried installing some updated drivers via a link on Adobe's site and also tried some from Oracle neither of which solved the problem. I ended up ultimately just replacing the SP with CFQUERIES due to being under a time crunch. On 6/14/07, AJ Mercer <[EMAIL PROTECTED]> wrote: > > Have you seen this article? > > > http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a&sli > ceId=1 > > > On 6/15/07, Justin Mundy <[EMAIL PROTECTED]> wrote: > > > > Hi folks, > > > > Has anyone ever encountered the following non-descriptive error > > message? > > > > [Macromedia][Oracle JDBC Driver]Object has been closed. > > > > We recently updated to CF 7.0.2 and are connecting with an Oracle 9i > > Database. The Oracle JDBC Driver is 3.50. > > > > The issue we are experiencing occurs consistently when we try to run > > a stored procedure that then calls some oracle functions that > > process some data before insertion into a table and then nearly > > imediately re-run the same batch of code. > > > > We suspect that the Oracle tables are not being released by > > ColdFusion after the first successful run of the code. > > > > Any ideas? We updated to 7.0.2 about 2 weeks ago, and now > > applications that have been behaving have suddenly began acting up. > > > > Thanks, > > > > Justin Mundy > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
