Foreign Key Cascade Delete
I set up a Foreign Key link with "On Update" & "On Delete" set to Cascade. I tested the schema with a few test records that were correctly linked by the foreign key. When I deleted a record from Master (1) table the linked records in the Dependent (Many) table were untouched. Why? I was under the impression that the current engine V5.6.17 implemented cascade delete. I have the no-cost public version.
Any help would be welcome.
Subject
Written By
Posted
Foreign Key Cascade Delete
June 06, 2014 04:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.