Make sure CF is patched
check out for latest db drivers
http://kb2.adobe.com/cps/000/42dcb10a.html
I was using Oracle a couple of years ago and recall having this issue - but
cant exactly remember the solution.
I know this fixed something along the way.
Are you using a JBDC connect?
Are you using the latest oracle client?
2009/10/19 Tomek Kott <[email protected]>
> Hi Folks,
>
> I have been having trouble with getting the following errors: (using CF 7,
> Oracle 9i, FC 5.1.9)
>
> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01000: maximum open cursors
>
> exceeded
>
> Now, from what I understand, if ColdFusion "Open Connections" (or whatever
> its called) is set low enough (say 200) and Oracle Open Cursors are set high
> enough (say 400) there shouldn't be this problem, since ColdFusion
> automatically closes open cursors after they are used.
>
> I ask because my server admin / dba keep telling me to check my code for
> open cursors, to which I keep replying that ColdFusion should take care of
> it if set properly and that it's not my fault. (I don't have access to CF
> Admin / DBA personally )
>
> Any help with this would be very nice before I push the problem further up
> the management ladder.
>
> Thanks,
>
> Tomek
>
> >
>
--
AJ Mercer
Web Log: http://webonix.net
--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---
