You need an underscore between 'PACKAGE' and 'BODY':
SQL> SELECT DBMS_METADATA.GET_DDL ('PACKAGE_BODY','SWBT_T2_REMEDIES')
2 as txt from dual;
-----Original Message-----
From: OLIVA PAULINE C (SBCSI)
[mailto:oracledba-ezmlmshield-x97237929.[Email address protected]
Sent: Wednesday, May 10, 2006 1:05 PM
To: LazyDBA Discussion
Subject: Dbms_metadata.get_ddl
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
#####################################################################################
CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are confidential. It is neither an offer to buy or sell, nor a solicitation of an offer to buy or sell, any securities or any related financial instruments mentioned in it. If you are not the named recipient please notify the sender and immediately delete it. You may not disseminate, distribute, or forward this e-mail message or disclose its contents to anybody else. Unless otherwise indicated, copyright and any other intellectual property rights in its contents are the sole property of Mizuho Securities USA Inc. E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Although we routinely screen for viruses, addressees should check this e-mail and any attachments for viruses. We make no representation or warranty as to the absence of viruses in this e-mail or any attachments. Please note that to ensure regulatory compliance and for the protection of our customers and business, we may monitor and read e-mails sent to and from our server(s).
#####################################################################################
Oracle LazyDBA home page