I'm running Coldfusion 5.0 on a RedHat 7.2 box connected via Native
Drivers to an Oracle 8.1.7 database. I am getting the following error
whenever I attempt to insert a record of type long over about 4000
characters:


Oracle Error Code = 1704

ORA-01704: string literal too long

SQL = "insert into testLong(characters, data)
VALUES(4100, {a whole lot of zeros})

Any help would be greatly appreciated. This worked fine on my old setup,
which was a CF 4.01 connected to Oracle 7.1.3.4 via ODBC.

Thanks.

Josh Freeman

-- 
Josh Freeman
Technical Manager
Center for Assistive Technology and Environmental Access 

______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to