Is it possible to extract ddl package without packaging case

Question

I am using the dbms_metadata.get_ddl function. I extract the ddl of the package and package body separately and use them separately, so I don't need the DACK of the PACKAGE BODY package when I request DACK PACKAGE. However, get_ddl ('PACKAGE', some_package) returns the DACK of the PACKAGE and PACKAGE BODY packets together. Is there a parameter to install or something else to make this possible ...

Answer 1

Try dbms_metadata.get_ddl('PACKAGE_SPEC', some_package instead) (similar to PACKAGE_BODY )

Answer 2

For a well-formed ddl extraction and easy to use, you can get ZoraDDL. This is a little commandlinetool to retrieve DDL from a database with many features. See the ZorraDDL homepage for more information.