Oracle 8.0.5
I want a after-insert-trigger for tabel A to insert new data in a second
table B that has a foreign key constraint to the table A.
Even though I defined the constraint with the option DEFERRABLE INITIALLY
DEFERRED is seems like the insert command for table B within the
after-insert-trigger for table A wants the foreign key constraint checked
immediately and therefore ends up in an oracle error, because the process of
checking envolves reading table A.
Is there any solution to that? (besides inactivating the constraint?)
Thanx for any hints and comments!
Markus
Received on Wed Jan 19 2000 - 17:17:42 CST
