> I ran into this problem a while back. Apparently Cold Fusion has
> difficulties putting more than 4000 characters at a time into
> a CLOB in Oracle. I ended up writing a little PL/SQL script that
> would break down a character string passed to it into chunks and
> insert them one by one. I'm not sure if it will work on an NCLOB
> datatype, but it sounds very similar and I was getting the same
> error. I have the CF Code and the accompanying PL Code. Will post
> it tomorrow morning when I get to work.
If you're using CF 4.5.x, you shouldn't need to break data into chunks
anymore. You can use CFQUERYPARAM to put a large string into a bind
parameter.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
