How to insert data to LONG fields using simple SQL statements??
From: Albert Yu <ayu_at_bnr.ca>
Date: 1995/11/06
Message-ID: <47m22e$rb6_at_bcarh8ab.bnr.ca>#1/1
Date: 1995/11/06
Message-ID: <47m22e$rb6_at_bcarh8ab.bnr.ca>#1/1
I am having a problem inserting data to a LONG field. I am doing something like the following....
INSERT INTO testing VALUES('ddddddddddddddddddddddddddddddddddddd ddddddddeeeeeeeeeeeeeeeee..... ......30 lines or so.... ggggggggggggggggggggg');
The TABLE testing has just one LONG field. The error I am getting is this:
ERROR at line 4:
ORA-01704: string literal too long
How can insert data to this LONG field with simple SQL statement and not using any PL/SQL commands??
Thanks in advance,
-- Albert Yu Prism Systems Inc. EMAIL: ayu_at_bnr.caReceived on Mon Nov 06 1995 - 00:00:00 CET