Re: Inserting data into field of type LONG
From: Mark Woytus <mwoytus_at_divcomp.com>
Date: Wed, 10 Jun 1998 17:14:57 GMT
Message-ID: <357ebadb.13268870_at_news.dave-world.net>
Date: Wed, 10 Jun 1998 17:14:57 GMT
Message-ID: <357ebadb.13268870_at_news.dave-world.net>
On Mon, 08 Jun 1998 15:53:32 -0700, Pax Prakarsa <pax_at_webeasy.com>
wrote:
<snip>
>I am having problem doing:
>
>insert into mytable values(1,'This text is over 2000 characters.....');
>
>mytable has 2 columns:
>1. index, type NUMBER
>2. text, type LONG
>
>The error message that Oracle returns is:
>ORA-01704: string literal too long
There is a 2000-character limit on character literals. To insert
longer values, you need to use bind variables. You can't do this in
sqlplus. You'll have to use pl/sql or embedded sql.
Mark Woytus (w)309.888.8423 (f)309.888.8246
Diversified Computer Consultants
mwoytus_at_divcomp.com woytus_at_acm.org
Received on Wed Jun 10 1998 - 19:14:57 CEST