Try,

SELECT DBMS_METADATA.GET_DDL ('PACKAGE_BODY','SWBT_T2_REMEDIES') as txt
from dual;



"OLIVA PAULINE C \(SBCSI\) "
<oracledba-ezmlmshield-x97237929.[Email address protected] wrote on
05/10/2006 01:04:36 PM:

> 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
>
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


--
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Oracle LazyDBA home page