CREATE TABLE me_and_my_lovelies (name VARCHAR2 (100))

BEGIN 
   INSERT INTO me_and_my_lovelies VALUES ('Grandpa Steven'); 
   INSERT INTO me_and_my_lovelies VALUES ('Loey'); 
   INSERT INTO me_and_my_lovelies VALUES ('Juna'); 
   COMMIT; 
END; 

CREATE OR REPLACE PROCEDURE not_auton_no_commit 
   AUTHID DEFINER 
IS 
BEGIN 
   UPDATE me_and_my_lovelies 
      SET name = UPPER (name); 
END not_auton_no_commit; 

CREATE OR REPLACE PROCEDURE not_auton_commit 
IS 
BEGIN 
   not_auton_no_commit (); 
END not_auton_commit; 

CREATE OR REPLACE PROCEDURE auton_commit 
   AUTHID DEFINER 
IS 
   PRAGMA AUTONOMOUS_TRANSACTION; 
BEGIN 
   not_auton_no_commit (); 
 
   COMMIT; 
END auton_commit; 

BEGIN 
   auton_commit; 
END; 

SELECT COUNT(*) low_name 
  FROM me_and_my_lovelies 
 WHERE name <> UPPER (name)