dbms_metadata.get_ddl Returns Error Ora-06502, LPX-00210

9.2.0.7
SQL> select dbms_metadata.get_ddl('TABLE','CONTAINER') from dual;
 
select dbms_metadata.get_ddl('TABLE','CONTAINER') from dual
 
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 466
ORA-06512: at "SYS.DBMS_METADATA", line 629
ORA-06512: at "SYS.DBMS_METADATA", line 1246
ORA-06512: at line 1
 

Reload the XML API。

1.sqlplus " / as sysdba"
2. alter system enable restricted session;
3. 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.

get following error at catmet.sql running:
ORA-31609: error loading file "kubody.xsl" from file system directory "/u01b/app/oracle/product/9.2.0.1/rdbms/xml/xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 604
ORA-06512: at line 1

5. modify initmeta.sql(in catmet.sql)
EXECUTE SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS('/u01b/app/oracle/product/9.2.0.1/rdbms/xml/xsl');
--&gtEXECUTE SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS('/u04/app/oracle/product/9.2.0.1/rdbms/xml/xsl');

6. step 1,2,3
7. alter system disable restricted session

Article-ID: Note 364214.1
Circulation: REVIEW_READY (EXTERNAL)
Folder: server.DBA.Admin
Topic: Miscellaneous
Title: P: dbms_metadata.get_ddl Returns Error Ora-06502, LPX-00210
Document-Type: HOWTO
Impact: LOW
Skill-Level: NOVICE
Updated-Date: 10-APR-2006 05:27:29
References:
Authors: DANGHEL.RO
Attachments: NONE
Content-Type: TEXT/X-HTML
Products: 5/RDBMS.RDBMS (9.2.0.7);
Platforms: 0;


In this Document
Goal
Solution

-------------------------------------------------------------------
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.7
Information in this document applies to any platform.
Goal#1. How to solve the following situation?
select dbms_metadata.get_ddl('INDEX', 'IX_ATRT_SPEEDUP',
'GOIHUBATHIATCL') FROM
DUAL;
19:12:10 SQL> 19:12:10 SQL> 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 466
ORA-06512: at "SYS.DBMS_METADATA", line 629
ORA-06512: at "SYS.DBMS_METADATA", line 1246
ORA-06512: at line 1

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.
--------------------------------------------------------------------------------

Please let me know if you need any other clarifications.

Regards
Bharath.S

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

转载于:http://blog.itpub.net/386081/viewspace-503463/