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