I have encountered the below error while generate awr report by toad.
2.6 Message : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512 : at "SYS.DBMS_WORKLOAD_REPOSITORY", line 313
ORA-06512 : at line 1
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
cd $ORACLE_HOME/rdbms/admin
. oraenv
enter yictldt10g
sqlplus system/password as sysdba
@awrrpt.sql
ERROR:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 313
ORA-06512: at line 1
Oralce的一些版本,当在函数里执行了min/max操作,并且这个min/MAX的参数是一个char型的字段
将出错,这是一个BUG,BUG号Bug 4458790
http://atgc.itpub.net/post/22412/389787