摘要： 执行存储过程中报如下错误：ORA-06502: PL/SQL: numeric or value error: character string buffer too small经过排查，发现是由于赋予变量的值超过了变量定义的长度。定义的字符变量长度为3位：v_operator_1 varchar2(3);实际上赋予变量的值threshold_operator中有多余的两位空格字符，导致实际字符大于了3位：select threshold_operator, threshold_value into v_operator_1, f_threshold_1 from t_conf_thresh. 阅读全文