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
SQL> desc ttt;
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