为什么LONG类型超4000字节出错??
请看一下两例:
1、
PROCEDURE proc_SQLTOLONG
IS
CURSOR cur_A IS
SELECT * FROM P_AISQLINFO;
BEGIN
DBMS_OUTPUT.PUT_LINE('begin.....');
DBMS_OUTPUT.PUT_LINE(SYSDATE);
FOR row_set IN cur_A LOOP
BEGIN
update P_AISQLINFO_new
set EDITLIST= --是LONG类型
'[TITLE]'||chr(10) || row_set.TITLELIST || '[SQL]'||chr(10) || row_set.SQLLIST
|| '[VARIABLE]'||chr(10) || row_set.VARIABLELIST || row_set.EDITLIST
-- 这些信息串联起来不过10000字节 出错-01489 ---
WHERE NAME=row_set.NAME;
-------------------------------------------------------------------------
2、 update P_AISQLINFO_new
set EDITLIST= --是LONG类型
‘XXXXXXXX..........................FFFFFFFFFFFFFFFFFF'
当超过4000字节时,也出错!!!
================================================
请高手解答!谢谢!