tags:

views:

34

answers:

1

I am using dbms_metadata.get_ddl function. I extract ddl of package and package body seperate and use them separately, so i dont need PACKAGE BODY's ddl when i ask for PACKAGE ddl. However get_ddl('PACKAGE',some_package) returns PACKAGE and PACKAGE BODY's ddls together. Is there a parameter to set, or anything else to make this possible...

+5  A: 

Try get_dll('PACKAGE_SPEC', some_package instead) (there is similar with PACKAGE_BODY)

GôTô
Thanks, that is it.
Serkan Kasapbaşı