How to call the function and Procedure in trigger?

Question Posted / gdipti_29

3 Answers
10757 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to call the function and Procedure in trigger?..

Answer / rakesh keshu

With the help of call statement..without semicolon

create or replace trigger tri_call

begin
call p1()

end tri_call;

Is This Answer Correct ?

12 Yes

0 No

How to call the function and Procedure in trigger?..

Answer / pranabesh

Procedures can be called directly by name with parameters
[if any] in the trigger

ex:
suppose i have a procedure pro1(var1 in number, var2 in
number) which i want to call from trigger trig1

CREATE OR REPLACE TRIGGER TRIG1
AFTER UPDATE OF SAL ON EMP
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE

L_VAR1 NUMBER;
...
...
BEGIN
...
...
-- CALLING THE PROCEDURE

pro1(10,20);
END

Is This Answer Correct ?

4 Yes

0 No

How to call the function and Procedure in trigger?..

Answer / pradeep aryan

hi this is Sql server Statement:

Create table findSalary(salay int)

-- create procedure
Create proc stp_testdata
as
begin
select * from findsalary
end
-- Create function
create function Function4()
returns varchar
as
begin
return 'test data'
end
-- insert command
insert into findsalary values (89)

this is working fine

Is This Answer Correct ?

0 Yes

3 No

Post New Answer