tdk wrote:
> 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
Yes. But it looks like Maxim did your work for you.
--
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 12:08:02 CDT
