ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-06502: PL/SQL: numeric or value error

ORA-06502: PL/SQL: numeric or value error

原创 Linux操作系统 作者:rocky_gao 时间:2011-04-22 23:14:36 0 删除 编辑
SQL>   SELECT dbms_metadata.get_ddl('TABLESPACE','TEMP') FROM dual;
ERROR:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3688
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4544
ORA-06512: at "SYS.DBMS_METADATA", line 458
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1222
ORA-06512: at line 1

Prior to 9.2.0.6, this situation is caused by:Bug.3361288 (80)

Solution#1.  The solution is to reload the XML API:
1. enable restricted database session
2. run:
(from $ORACLE_HOME/rdbms/admin):
catnomet.sql
rmxml.sql
to remove the xml subsystem and after that: catxml
utlcxml.sql
prvtcxml.plb
catmet.sql
to reload it.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11976525/viewspace-693191/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-04-09

  • 博文量
    112
  • 访问量
    278976