Re: dbms_metadata.get_ddl error / 9206 / solaris8

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

Maybe it's maintenance related a number of bugs and fixes to that package in the 9.x patchsets.

Do you want to try putting in 9208 in a test system and see if it goes away? Received on Sun Sep 10 2006 - 18:15:06 CDT