Package: estrazione DDL ed esecuzione
Estrazione DDL del package body + spec di un package:
select dbms_metadata.get_ddl('PACKAGE','<PACKAGE_NAME>','<OWNER_NAME>') from dual;
Estrazione ddl del package body:
select dbms_metadata.get_ddl('PACKAGE_BODY','<PACKAGE_BODY_NAME>','<OWNER_NAME>') from dual;
Esecuzione ddi un package:
SQL > SET SERVEROUTPUT ON
SQL > execute <schema>.<nome package>.<nome procedure>(parmetri);
Ricompilazione package:
ALTER PROCEDURE <schema>.<nome package> COMPILE;
ALTER PROCEDURE <schema>.<nome package> COMPILE BODY;
SQL> select text from DBA_SOURCE where name = 'nome package'
select dbms_metadata.get_ddl('PACKAGE','<PACKAGE_NAME>','<OWNER_NAME>') from dual;
Estrazione ddl del package body:
select dbms_metadata.get_ddl('PACKAGE_BODY','<PACKAGE_BODY_NAME>','<OWNER_NAME>') from dual;
Esecuzione ddi un package:
SQL > SET SERVEROUTPUT ON
SQL > execute <schema>.<nome package>.<nome procedure>(parmetri);
Ricompilazione package:
ALTER PROCEDURE <schema>.<nome package> COMPILE;
ALTER PROCEDURE <schema>.<nome package> COMPILE BODY;