摘要:
这个BUG出现会报错如下:selectto_char(max(RENEWAL_DATE))intoM_YEAR_MONTHfromt_renewal_schedule;ORA-06502: PL/SQL:数字或值错误:字符串缓冲区太小这个时候有3个方法可以解决1、setting initialisation parameter BLANK_TRIMMING=TRUE2、declare PL/SQL CHAR and VARCHAR2 variable used in the INTO clause of SELECT statement as 4,000 bytes.3、Use CASTSQL 阅读全文