DateBase Trigger from a manual insert statement in Oracle form [message #420234] |
Thu, 27 August 2009 11:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Prerna
Messages: 1 Registered: June 2009
|
Junior Member |
|
|
Hi Experts,
I have a scenario where i have to insert/update/delete data in two tables from a data block. Table 1 and Table 2.
Data Block is created from Table 1.
Hence i update Table 2 in pre-update Trigger.
Now there is an after each row trigger on Table 2 which updates Table 3 on insert/update/delete on Table 2.
But this after each row trigger is not being called.
Does the Database trigger not get called when we manually insert/update/delete in Oracle form?
Thanks in Advance,
Prerna
|
|
|
|
|