Re: dbms_metadata.get_ddl error / 9206 / solaris8

From: tdk <tdk_at_dodgeit.com>
Date: 7 Sep 2006 09:59:48 -0700
Message-ID: <1157648388.626253.16600@m79g2000cwm.googlegroups.com>

Michel Cadot wrote:

> <tdk_at_dodgeit.com> a écrit dans le message de news: 1157640481.711298.201950_at_i3g2000cwc.googlegroups.com...

> | hello,
> |
> | trying to use dbms_metadata package w/ views and getting the following
> | :
> |
> | sql> select dbms_metadata.get_ddl('VIEW', '<myViewName>') from dual;
> |
> | ERROR:
> | ORA-19206: Invalid value for query or REF CURSOR parameter
> | ORA-06512: at "SYS.DBMS_XMLGEN", line 83
> | ORA-06512: at "SYS.DBMS_METADATA", line 345
> | "
> | "
> | "
> | "
> | " : at line 1
> |
> |
> | Any ideas why get_ddl doesnt work on views but does on tables?
> |
> | - thanks
> |

>
> SQL> create view v as select * from t;
>
> View created.
>
> SQL> select dbms_metadata.get_ddl('VIEW','V') from dual;
> DBMS_METADATA.GET_DDL('VIEW','V')
> ------------------------------------------------------------------------
>
>   CREATE OR REPLACE FORCE VIEW "MICHEL"."V" ("RNUM", "PAD1") AS
>   select "RNUM","PAD1" from t
>
>
> 1 row selected.
>
> SQL> @v
>
> Version Oracle : 9.2.0.6.0
>
> Regards
> Michel Cadot

sql> create view mytestview as select * from emp;

view created.

sql> select dbms_metadata.get_ddl('VIEW', 'mytestview') from dual; ERROR:
ORA-19206 :...
ORA-06512: ... sql> select version from v$instance;
VERSION

---

9.2.0.6.0

So it looks like my dbms_metadata package is messed up. Can I just rebuild w/:

   catxml.sql
   utlcxml.sql
   prvtcxml.plb
   catmet.sql

• cheers

Received on Thu Sep 07 2006 - 11:59:48 CDT