Post Update Trigger [message #8425] |
Wed, 20 August 2003 04:24 |
Reema
Messages: 50 Registered: July 2003
|
Member |
|
|
HI All,
I need a little bit of suggestion from you all.
I have a table tab1 with following structure and data.
COL1 COL2 COL3
18 FLAG Y
18 YEAR 2003
18 MONTH 1
The API, will update each of these three rows in three different
update statements. The issue is that i have to write a trigger after
all three updates are over, cause there is a task which needs to be
done depending on the committed values of FLAG, YEAR AND MONTH.
Everything that I have tried leads me to mutating tables. Any
pointers would be highly appreciated.
|
|
|
Re: Post Update Trigger [message #8439 is a reply to message #8425] |
Wed, 20 August 2003 11:57 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Hard to say with only a description of "a task which needs to be done", but you will need to defer the processing to an after statement (AS) trigger. If something isn't supposed to happen until after the third update statement, you will need a package variable that is set to false before the first update and set to true before the last (third) update in order to conditionally fire the code in the AS trigger.
|
|
|