SQL>
SQL> CREATE OR REPLACE PROCEDURE Auto1 AS
2 PRAGMA AUTONOMOUS_TRANSACTION;
3
4 PROCEDURE Local IS
5 PRAGMA AUTONOMOUS_TRANSACTION;
6 BEGIN
7 ROLLBACK;
8 END Local;
9 BEGIN
10 Local;
11 COMMIT;
12 END Auto1;
13 /
Procedure created.
SQL> show errors
No errors.
SQL>
SQL>