>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 >
The database itself might be able to handle the size with no problem, but sometimes the calling service or the drivers that pass the data do not. That's why I suggested using cfqueryparam to see if that resolves your issue. In fact, in our case, we were having problems with truncated strings when doing sa select from the database for our CLOB field, and once we switched to cf_sql_longvarchar, all was fine. By your last sentence, are you saying that you resolved the issue? Regards, Dave. _________________________________________________________________ Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137467 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 Get the mailserver that powers this list at http://www.coolfusion.com
