Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting long data

Re: Inserting long data

From: Brad Worsfold <bworsfold_at_vic.lgs.ca>
Date: 1997/11/04
Message-ID: <01bce93d$c0364430$0faf22cf@cerulean>#1/1

How are you trying to insert the data??? You should be able to insert values way over 2000 characters into a long column.

If you give the table def, and exactly what you are doing, I may be able to help.

Brad

David P. Baker <david_at_starmedia.com> wrote in article <345E103A.30F0A315_at_starmedia.com>...
> Hi. We're running into a problem that must have been solved already:
 we're
> trying to insert data into a LONG column, and we're getting "ORA-01704:
 string
> literal too long". According to the book, a string literal can have no
 more
> than 2,000 characters.
>
> Is there any way to get around this, except by splitting up the string
 and
> concatenating the (< 2,000 chars) pieces?
>
> Thanks.
>
> --
> David P. Baker
> Director of Engineering Voice:
 203.698.0777
> StarMedia Network, Inc. Fax:
 203.698.1524
> http://www.starmedia.com/ Email:
 david_at_starmedia.com
>
Received on Tue Nov 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US