| database triggers b/n a master and detail table [message #374997] |
Tue, 17 July 2001 22:34  |
HAB
Messages: 3
Registered: July 2001
|
Junior Member |
|
|
here's the scenario for my problem:
I have 2 tables, table1 has a primary that is a foreign key in table2 (table2 has the foreign key constraint). I created a database trigger on table1 for updates, inserts and deletes to update, insert or delete into table2. when i insert, update, or delete into table1 i recieve an error message that Oracle can not update/insert/delete.
When i remove the foreign key constraint from table2 (that tied table2 with table1), then i can insert/update/delete into table1 and the database trigger works.
Is there a way to make the database trigger work while keeping the foreign key constraint in table2?
Any help is appreciated,
thanx...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
