All CLOBS need to inserted using cfqueryparam (which you should be using anyway).
Your query inserts a literal string, which is limited to 4000 bytes, no matter that the column datatype. On 9/27/07, Carlos Paez Jr <[EMAIL PROTECTED]> wrote: > Thanks for the replies and ideas. > The datatype of my column is SYS.XMLTYPE which I understood to be a CLOB; > which is the source of my confusion. CLOBs should hold up to 4 gig of data. > I'm thinking that this error might not be referring to the datatype of my > column, but rather, that oracle is not able to handle the length of the > string I'm inserting as #XMLSTRING# > > Michael, I think your solution would work, but like you said, I think there > must be a better way to do it now-a-days. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
