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
