ORA-06502

2011-04-21  张林 

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
563°/5631 人阅读/0 条评论 发表评论

登录 后发表评论