[Macromedia][Oracle JDBC Driver][Oracle]ORA-01000: maximum open cursors exceeded

2007-04-18 Thread Brad Stone
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: Err

Please Help! ORA-01704: string literal too long Error (CFMX)

2007-04-17 Thread Brad Stone
All: I have a situation where well-formed INSERT or UPDATE pass-thru queries fail through the native Oracle driver, but executes successfully in Toad or SQL*Plus: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string literal too long I'm running CFMX 6.1 and Oracle 10G. I've verified t