"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:o1q7l1d7p0cam42dug88r5hchdb1ii33lq_at_4ax.com...
> On Mon, 17 Oct 2005 17:54:41 GMT, "Jack Addington"
> <jaddington_at_shaw.ca> wrote:
>
>>If I have an after statement trigger defined as
>>
>>cREATE OR REPLACE TRIGGER some_table_aius
>>after INSERT or update
>>on some_table
>>declare
>>
>>begin
>>
>> do_some_process( xxx );
>>
>>end;
>>
>>and then I do:
>>
>>insert into some_Table(...)
>>insert into some_table (...)
>>update some_table set xxx where yyy
>>
>>commit;
>>
>>will the do_some_process function fire twice, once for updates and once
>>for
>>inserts or just once?
>>
>>thx
>>
>>jack
>>
>
> You have three distinct statements, so the trigger will fire 3 times.
>
> --
> Sybrand Bakker, Senior Oracle DBA
This is a statement trigger, not a row trigger.
Received on Mon Oct 17 2005 - 13:22:13 CDT
