Oracle問題.大俠們請help me!
我有一個存儲過程.創建時可以,但調用時出錯.
Oracle報錯:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
我在script中查找,發現有一個varchar2型的變量賦值如下:
v_sql := 'INSERT INTO temp_status(id, fod00c,fod01c,fod02d,fod03c,fod04c,fod06c,fod11c,a0,a1,a2,a3,a4,' ||
'a5,a6,a7,a8,a9,a10,a11,a12,k1,k2,tba03c,sba02c) ' ||
' SELECT temp_status_seq.nextval, fod00c,fod01c,fod02d,fod03c,fod04c,fod06c,fod11c,' ||
'fia14c,0,0,0,0,0,0,0,0,0,0,0,0,fod19f,0,TRANSLATE(tba03c USING CHAR_CS),TRANSLATE(sba02c USING CHAR_CS) ' ||
' FROM fom04, fim01, tbm01, sbm01 ' ||
' WHERE fod00c = fia00c and fod11c = fia01c' ||
' AND tba010c = ''B'' and fod03c=tba011c' ||
' AND fod08c = sba01c';
將這段腳本縮減後就能執行.
現在我想詢問一下,有沒有辦法解決這個問題,例如說將其強制分行.