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ô
2010-10-21 08:12:43
Thanks, that is it.
Serkan Kasapbaşı
2010-10-21 08:20:19