SQL> SELECT dbms_metadata.get_ddl('TABLESPACE','TEMP') FROM dual;
ERROR:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '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.
ERROR:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11976525/viewspace-693191/