Execution of DBMS_METADAT.GET_DDL results in ORA-19206,ORA-6512_292266.1

rongshiyuan發表於2015-03-12

Execution of DBMS_METADAT.GET_DDL results in ORA-19206,ORA-6512 (文件 ID 292266.1)


In this Document

Symptoms
Cause
Solution
References

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.


Symptoms

Execution of dbms_metadata.get_ddl results in ORA-19206,ORA-6512

e.g.
SQL> select dbms_metadata.get_ddl('TABLE','TEST') from dual;
ERROR:
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-6512: at "SYS.DBMS_XMLGEN", line 83
ORA-6512: at "SYS.DBMS_METADATA", line 345
ORA-6512: at "SYS.DBMS_METADATA", line 410
ORA-6512: at "SYS.DBMS_METADATA", line 449
ORA-6512: at "SYS.DBMS_METADATA", line 615
ORA-6512: at "SYS.DBMS_METADATA", line 1221
ORA-6512: at line 1

Cause

This error may occur if either XML Database in not installed or has not been installed properly.

Solution

Reinstall XML Database (XDB)

Reference: <> - Master Note for Oracle XML Database (XDB) Install / Deinstall

References


BUG:4004998 - DBMS_METADATA.GET_DDL ON TABLE GETS ORA-19206
NOTE:1292089.1 - Master Note for Oracle XML Database (XDB) Install / Deinstall

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1457031/，如需轉載，請註明出處，否則將追究法律責任。

相關文章