Recursive Triggers

[royjimenez]

hi!

1. I need to insert a row into the table A but it will fire a trigger and it will add a new row into the table B, BUT, I need to do it reciprocally. I have problems with infinite loop, but i have been reading but i can't fix my problem.

2. In SQL server, when I insert several rows with an insert i can catch them into a trigger with inserted table, how can i do this in ORACLE ?

Can somebody help me ?

Thanks a lot !!!

 

[sem]

You may use some package variable as a semaphore. It may be accessed from triggers to stop recursion.

Regards, Dima