Can we use function inside a trigger

Is it possible to use function inside a trigger.

Showing Answers 1 - 6 of 6 Answers

tinku981
Profile Answers by tinku981 Questions by tinku981

Jun 16th, 2013

Yes, by using CALL statement.

tinku981
Profile Answers by tinku981 Questions by tinku981

Jun 16th, 2013

Code
CREATE OR REPLACE TRIGGER emp_trig


  before INSERT ON emp


  FOR each row


--referencing old as old and new as new


declare


  i pls_integer;


begin


  emp_pro;


  i := emp_func;


  dbms_output.put_line(TRIGGER called AND FUNCTION returned  || i);


 


end;