Re: dbms_metadata.get_ddl error / 9206 / solaris8

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 7 Sep 2006 18:23:25 +0200
Message-ID: <4500477c$0$31322$626a54ce@news.free.fr>

<tdk_at_dodgeit.com> a écrit dans le message de news: 1157640481.711298.201950_at_i3g2000cwc.googlegroups.com...
| 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
|

SQL> create view v as select * from t;

View created.

SQL> select dbms_metadata.get_ddl('VIEW','V') from dual; DBMS_METADATA.GET_DDL('VIEW','V')

CREATE OR REPLACE FORCE VIEW "MICHEL"."V" ("RNUM", "PAD1") AS select "RNUM","PAD1" from t

1 row selected.

SQL> @v

Version Oracle : 9.2.0.6.0

Regards
Michel Cadot Received on Thu Sep 07 2006 - 11:23:25 CDT