Re: dbms_metadata.get_ddl error / 9206 / solaris8

From: tdk <tdk_at_dodgeit.com>
Date: 7 Sep 2006 10:04:09 -0700
Message-ID: <1157648649.048434.276570@i42g2000cwa.googlegroups.com>

DA Morgan wrote:
> fitzjarrell_at_cox.net wrote:
> > 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

>

> My answer would be DBMS_METADATA is preferable as it gives the full
> DDL statement for recreating the view.

>

> To the OP: I've seen that before but I can't recall the circumstances.
> Can you run GET_DDL against a fixed table in the local schema?

>

> Might also want to check metalink.
> --
> Puget Sound Oracle Users Group

Yes, against a table the get_ddl runs just fine...

(havent found anything in metalink that matches this problem w/ views, but not tables) Received on Thu Sep 07 2006 - 12:04:09 CDT