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?
>
> - thanks

Any particular reason you're not using the USER_VIEWS view? The TEXT column provides the DDL.

David Fitzjarrell Received on Thu Sep 07 2006 - 11:25:15 CDT