Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_metadata.get_ddl error / 9206 / solaris8

Re: dbms_metadata.get_ddl error / 9206 / solaris8

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 12:36:11 -0700
Message-ID: <1157657767.516870@bubbleator.drizzle.com>


tdk wrote:

> 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)

Does the view involve any system tables or tables in schemas other than the one in which you are running DBMS_METADATA?

-- 
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 14:36:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US