SQL statement. PLEASE DO NOT COPY ANSWER FROM OTHER

Create a mechanism to check and prevent employees from getting a salary larger than their manager using trigger and procedure

table: employees (employee_id, name, salary, job_id, manager_id)

so my trigger would be

CREATE OR REPLACE TRIGGER salary_check

BEFORE UPDATE OF job_id, salary ON employees

FOR EACH ROW BEGIN check_salary(:new.job_id, :new.salary, :new.last_name);

END;

what would the corresponding procedure named "check_salary" for this?