|
|
Re: Fire triggers on a nested_table [message #684820 is a reply to message #684813] |
Sun, 29 August 2021 11:33 |
Solomon Yakobson
Messages: 3286 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
ryouga82 wrote on Fri, 27 August 2021 05:30Hello to all.
I just find that triggers on parent_table don't work in that case.
Yes, and it is all documented - inserting/updating/deleting from nested table doesn't fire main table triggers. Nested table is stored as a separate table (segment to be precise) and main table rows simply have pointers to their respective nested tables. So when we issue insert/update/delete directly against nested table main table isn't modified - all we do is select pointer from main table so obviouly no trigger is fired.
ryouga82 wrote on Fri, 27 August 2021 05:30Hello to all.
Also trying to reference directly the nested_table fails with ORA-22812
Correct. Nested table name can't be referenced directly in DML since technically it isn't top level object.
SY.
|
|
|