Yes you can do this.
Use CFQUERYPARAM and it should work fine. You might have to specify the
CFSQLType as CF_SQL_BLOB, but try it without first.
insert into testLong(characters, data)
VALUES(4100, <CFQUERYPARAM VALUE="#value#">);
-- Brett
At 03:26 PM 3/11/2002 -0800, you wrote:
>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.
