There are different restrictions under different versions of Oracle,
I believe your version has a restriction of 4095/6 characters per
"transmission across the wire". I've seen others having to put
together a special SP to concat numerous strings together to get
around this limitation. Earlier versions I think had a limitation
of 2047 chars / transmission. I have heard of similar restrictions
with ODBC as well...
Anyone else?
Steve
At 05:49 PM 3/11/2002 -0500, Josh Freeman wrote:
>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
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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.
