--raise_pay.sql

CREATE PROCEDURE raise_pay(eid NUMERIC, pct FLOAT)
UPDATE employee
   SET
     pay_amount = pay_amount * (1 + pct)
    WHERE
        id = eid;

CALL raise_pay(6400, .1);

SELECT * FROM employee
   WHERE
      id = 6400;

SELECT * FROM pay_change_log;
