This may be a CF Enterprise only thing but... When we changed the datasource for Oracle to Other, that error was resolved. As I understand it, Other is a JDBC connection
The parameters for our connection ar: JDBC URL:jdbc:macromedia:oracle://<server>:<port>;serviceName=<serviceName> Driver Class: macromedia.jdbc.MacromediaDriver Driver Name: DataDirect 3.5 just put in you values for <> (and loose the angle brackets) On 4/18/07, Brad Stone <[EMAIL PROTECTED]> wrote: > > All - > > I'm still grappling with a problem where I was getting the dORA-01024 > error (string literal too long) with a valid INSERT statement, and it was > recommended that (among other things) I used bind variables in my INSERT via > CFQUERYPARAM. I have done so. Now, I have a different error: > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver][Oracle]ORA-01000: maximum open cursors > exceeded > > ARRGH. I have to get this working by Saturday. Does anybody have any > ideas? > > Many thanks, > -Brad > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
