ITPub博客

首页 > 数据库 > Oracle > Execution of DBMS_METADAT.GET_DDL results in ORA-19206,ORA-6512_292266.1

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

Oracle 作者:rongshiyuan 时间:2015-03-12 11:34:03 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2009-11-24

  • 博文量
    798
  • 访问量
    3206383