dbms_metadata.get_ddl error / 9206 / solaris8

From: <tdk_at_dodgeit.com>
Date: 7 Sep 2006 07:48:01 -0700
Message-ID: <1157640481.711298.201950@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

Received on Thu Sep 07 2006 - 09:48:01 CDT