一個(gè)Procedure執(zhí)行時(shí)報(bào)錯(cuò)
401970002
401970003
401970004
401970005
401970006
401970007
400770001
200180009
400760023
480000015
480000008
480000003
480000005
401970009
401970011
BEGIN sendmail_apparatus; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "XIAOYAN.SENDMAIL_APPARATUS", line 33
ORA-06512: at line 1
-------------------------------------------------------------------------
經(jīng)查系STRHTML VARCHAR2(32760):=''; 太小了
但是 PLS-00215: String length constraints must be in range (1 .. 32767)
Varchar2最大32767?? 暈菜！！！！！！！！
不能用clob! 哎！
----------------------------------------------------------------------------