SQL>
SQL>
SQL> CREATE OR REPLACE PACKAGE Auto2 AS
2 PROCEDURE P;
3 END Auto2;
4 /
Package created.
SQL> show errors
No errors.
SQL>
SQL> CREATE OR REPLACE PACKAGE BODY Auto2 AS
2 PROCEDURE P IS
3 PRAGMA AUTONOMOUS_TRANSACTION;
4 BEGIN
5 COMMIT;
6 END P;
7 END Auto2;
8 /
Package body created.
SQL> show errors
No errors.
SQL>
|