> We have an Oracle 8.15 database. We have recently been experiencing periodic error meesage when some of our CF scripts try to execute an insert statement. The error that is returned is > > Error Message: Oracle Error Code = 1704<P>ORA-01704: string literal too long > > When I copy and paste the SQL insert statement into SQLPlus it inserts teh data, no problem. > > This is only happening with long strings of data (varchar(4000)). The one change I do make when I paste it into sqlplus is that I insert carriage returns into any single line that is too long. This is because SQLPlus has issues with lines that are too long and if I dont put these in then SQLPlus gives me a different error indicating it can't handle the length. > > Has anyone seen this behavior before? If not, does anyone know of a way to add line breaks into a string every 90 charachters or so (reemembering that the line breaks can't occur in the middle of a word) >
For strings that long, use cfqueryparam with the cf_sql_longvarchar type. We use CLOBs on CF 4.5 using cfqueryparam (11K, 12K, etc) with no problem. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137428 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
