Re: dbms_metadata.get_ddl error / 9206 / solaris8

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 09:59:39 -0700
Message-ID: <1157648375.47182@bubbleator.drizzle.com>

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

Received on Thu Sep 07 2006 - 11:59:39 CDT