Mutating Table. [message #4419] |
Fri, 06 December 2002 09:36 |
Afagela
Messages: 9 Registered: December 2002
|
Junior Member |
|
|
Please Advise.
I have to create a trigger of AFTER INSERT or DELETE FOR EACH ROW, where on the DELETE I have to do the workaround for the mutating table.
What is the best approach to this. I know that for mutating table, I have to create a pl/sql package table, row-level trigger and a statement-level trigger. In the row-level trigger, should I just go ahead and do my INSERT and on the DELETE is where i use the information stored in the pl/sql package. The statement trigger will only process the information from the DELETE of the row-level trigger.
Did I just confuse everyone? I am so new to pl/sql. If you have a better way of doing this please help. Thanks.
|
|
|
|