Calling procedure from trigger [message #657633] |
Wed, 16 November 2016 09:41 |
|
SW26477
Messages: 9 Registered: November 2014 Location: Location
|
Junior Member |
|
|
Hi,
Can anyone give me an example where we can call pkg.proc(pass bunch of data) from before update trigger.
I am creating a new before update trigger, where I am going to select some data from different table and pass this data to new pkg.proc().
I want something like this:
Create or replace trigger BUR
Before UPDATE
on my_table
REFERENCING NEW AS NEW OLD AS OLD
for each row
DECLARE
cursor c_deatils
is
select tab1.col1, tab1.col2, tab2.col3, tab2.col4, tab2.col5, tab2.col6
from tab1 a, tab2 b
where a.id = b.id;
begin
open c_deatils;
fetch c_deatils into l_table;
close c_deatils;
for i in l_table.first..l_lat_table.l_table loop
pkg.proc(l_table(i));
end loop;
end;
Also please give an example how pkg.proc structure will look like.
Thanks in Advance.
[Updated on: Wed, 16 November 2016 09:42] Report message to a moderator
|
|
|
|
|