We're running CFMX Standard on our web server and it connects to Oracle 9i via an ODBC Socket. I need to insert record that contains a CLOB field, but your common-or-garden insert returns
ORA-01704: string literal too long Using cfqueryparam instead, thusly: '<cfqueryparam cfsqltype="cf_sql_clob" value="#getParameters()#">' returns this error: "[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s)." This page http://oldlook.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_2074 1623.html suggests you should use the cfsqltype CF_SQL_LONGVARCHAR, but that returns the same error. It also suggests you can use the Oracle thin client, so long as you have the Oracle client installed (which the server has). So, I followed the instructions on this page http://www.macromedia.com/support/coldfusion/ts/documents/tn18344.htm downloaded ojdbc14.jar from the Oracle site, whacked it in "C:\oracle\ora92\jdbc\lib", set up a new DSN and accessing the development site seems to be running find using it. So, before I go ahead and change the ODBC Socket on the production server to the thin client, can CLOB inserts / updates / retrieves really only be done using the JDBC driver? The MM page says "The Oracle thin driver does not comply to the JDBC 3.0 specification" Could that be a problem? Is there any reason not to use the JDBC driver and see if we crowbar ODBC to bend to our evil whims? Thanks. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> Fairbanks uses anti-spam filtering. If you sent an e-mail and expected to receive a response but didn't, please call -- it may be that your e-mail didn't make it to the intended mailbox. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
