Re: dbms_metadata.get_ddl error / 9206 / solaris8

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 07 Sep 2006 18:57:48 +0200
Message-ID: <45004fac$0$8255$9b4e6d93@newsspool4.arcor-online.net>

tdk_at_dodgeit.com schrieb:
> 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
>

If you have Metalink access, maybe Note:206313.1 can help you.

Best regards

Maxim Received on Thu Sep 07 2006 - 11:57:48 CDT