عندي بروسيجر

كيف اعمل لها استدعاء عن طريق التريقر

create or replace PROCEDURE salary_bouns
IS
BEGIN
UPDATE employee
	SET  sallary = sallary + (sallary *0.1)
	WHERE years_of_service>20;

END;

CREATE OR REPLACE my_procedure (p_variable1 IN my_table.column1%type, p_variable2 IN my_table.column2%type, p_out OUT number)
AS
BEGIN
p_out := p_variable1 + p_variable2 ;
END ;
CREATE OR REPLACE TRIGGER my_test_trigger
BEFORE INSERT ON my_table
DECLARE v_out number ;
BEGIN
my_procedure(:new.column1, :new.column2, v_out) ;
:new.column3 := v_out ;
END; 

شكرا
جزاك الله خير........