Hi!

Anyone know how to get around the following: (and why is it invalid
anyway?)

SQL> SELECT DBMS_METADATA.GET_DDL ('PACKAGE BODY','SWBT_T2_REMEDIES')
2 as txt from dual;

ERROR:
ORA-31600: invalid input value PACKAGE BODY for parameter OBJECT_TYPE in
function GET_DEPENDENT_DDL
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 1572
ORA-06512: at "SYS.DBMS_METADATA_INT", line 1960
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3999
ORA-06512: at "SYS.DBMS_METADATA", line 504
ORA-06512: at "SYS.DBMS_METADATA", line 560
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-06512: at line 1





Oracle LazyDBA home page