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&sliceId=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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
