How to insert data more then 4Kb into LONG data type?

From: (wrong string) ³\ªÃ³Í <cary_at_autumn.ccl.itri.org.tw>
Date: Mon, 10 May 1999 22:53:37 +0800
Message-ID: <7h6rpe$ev5$1_at_news.itri.org.tw>



Hi, all

When I insert about 4K data into a table with LONG data type, oracle will occur ORA-01704 or ORA-1489 error message. But LONG data type supports 4 gigabytes. Then how to insert large data into it?

Thanks!

Cary

Here is my test file:




SQL> desc ttt;
 Name                            Null?    Type
 ------------------------------- -------- ----
 NNN                                      NUMBER(5)
 CCC                                      CHAR(20)
 LLL                                      LONG

SQL> insert into ttt
  2 (nnn,ccc,lll)
  3 values(5,'2'||'3'||'4',
  4 '1234567890'||
.......

ORA-01489: result of string concatenation is too long Received on Mon May 10 1999 - 16:53:37 CEST

Original text of this message