the strange thing about this is that the field size is 4k and the data that is trying to be inserted is less than 4k. Anything I have found on oracle says that it can handle 4k no problem
>> 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:137445 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com