Live ORACLE

CREATE OR REPLACE PROCEDURE Lower_salary

     (emp_id  NUMBER,

      amount  NUMBER)

AS

  PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN

  UPDATE employees

  SET    salary = salary

                    - amount

  WHERE  employee_id = emp_id;

  COMMIT;

END lower_salary;

/

Declaring an Autonomous Standalone Procedure