I call "DBMS_METADATA.GET_DDL" to get package body source code, see example call below.
Can i be always sure that it will always:
1. Return schema name before package name as for example this: "MYSCHEMA"."COLLECTSTATS". Or may it return sometimes without schema/owner-name the package name as " CREATE OR REPLACE PACKAGE BODY "COLLECTSTATS" IS"
2. Will it always be in capital letters the "owner.packagename" part?
3. wil lthere always be Double quotes surrounding package name and owner name as "MYSCHEMA"."COLLECTSTATS"?
select DBMS_METADATA.GET_DDL('PACKAGE_BODY','COLLECTSTATS','MYSCHEMA') from DUAL;
Result:
CREATE OR REPLACE PACKAGE BODY "MYSCHEMA"."COLLECTSTATS" IS
PROCEDURE save_log(p_logrec IN LiveStatsLog%ROWTYPE) IS