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>


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

Original text of this message