At 03:52 PM 5/17/2001 -0400, you wrote:
>How do I write an insert statement in CF to insert data which is more than 
>4000 characters into a LONG field in my oracle database? ( I remember 
>someone asking this previously, but I don't think that I have the answer)

With a stored procedure. You need to get around the 4k literal text string 
maximum on insert and update statements. I don't have an example handy but 
if no one comes up with an example, let me know.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to