Wow, haven't run into that one in a long time.
Some of this is from the CF 5 days, but one or a combination of these should
help.
1. Make sure there aren't any restrictions set on the datasource in the
ColdFusion administrator ("Enable retrieval of long text" disabled, etc.)
2. Try a different driver - as Dave suggested, first make sure you have the
most up-to-date CF drivers, and if that doesn't help, try an alternate JDBC
driver, or even ODBC a shot.
3. Use CFQUERYPARAM. This one was generally the "magic bullet" for me in the
past. Oracle just seems much happier getting long string data in a bind
variable rather than as a literal.
On 4/17/07, Brad Stone <[EMAIL PROTECTED]> wrote:
>
> 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 this in three
> Oracle/CF instances. There are no extended character sets (all one byte
> characters.) Using default Oracle 10G character set.
>
> I am aware that this was an issue with versions of CF prior to version 5.0-
> all the posts out there simply seem to interate this fact (but it doesn't
> help in solving the problem.) Has there anybody out there dealt with this
> problem, and found a fix (outside of using CLOBS?)
>
> Thanks!
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275597
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
