Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting long data
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
![]() |
![]() |