Add employee

CREATE OR REPLACE PROCEDURE ADD_EMPOYEE(p_id VARCHAR(5), p_name VARCHAR(20), p_surname VARCHAR(30), p_payclass INT)
AS
   v_wage INT := 0;
BEGIN
   INSERT INTO Employee(id, name, surname, payclass) VALUES(p_id, p_name, p_surname, p_payclass);
   SELECT wage INTO v_wage FROM Wages WHERE (payclass = p_payclass);
   UPDATE Employee SET wage = v_wage WHERE id = p_id;
   COMMIT;
EXCEPTION
   WHEN others THEN
      ROLLBACK;
END;