Inserting data into field of type LONG

From: Pax Prakarsa <pax_at_webeasy.com>
Date: Mon, 08 Jun 1998 15:53:32 -0700
Message-ID: <357C6B6C.3271B1D9_at_webeasy.com>



Hi,
I am sorry for such a basic question.

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

Thanks in advance!
Pax Received on Tue Jun 09 1998 - 00:53:32 CEST

Original text of this message