I am trying to update a record into my database one field of which is a LONG
datatype (> 2Gb). If I put more than 2000 chars in I get the Oracle error :
String literal too long (#01704). The long datatype is supposed to accept
upto 2 gig of data but it is acting like VARCHAR2 in that it fails with
anything over 2000 chars. The SQL qurey I'm running looks something like this
:
UPDATE prod.master_table SET
DESCRIPTION = '#Form.txtDescription#',
WHERE M_ID = '#Form.hidReqId#'
Where the Description field is the LONG datatype.
I've had a look at the Oracle web site and it mentions OCI calls for LONG
datatype but can't find any reference to this in CF help pages.
Appreciate this is more of an Oracle question than Cold Fusion but just hoping
that one of us out there has done something similar ;->
Cheers............Steve
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
