Re: quick question about after statement triggers

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