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

there's been a number of bugs with dbms_metadata.

try re-running catmet, and if that doesn't work , speak to support

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------