Re: Inserting long data

David P. Baker wrote:

> 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?
>

How about up to 32K using pl/sql and a pl/sql variable that is defined as varchar2(32760). the only problem is you still cant do the > 2K input string from keyboard.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net (home)
Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second, third, etc,
instance, without using oracle's installer, database scripts.
ICQ UIN:  2832230(&oracle, home).