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


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.ca
Received on Mon Nov 06 1995 - 00:00:00 CET

Original text of this message