delete entity that map with another entity

Question

entity A --> id, entity_a_name, foreign_key_entity_B entity B ---> id, entity_b_name

when i delete entity B record, it suppose to auto delete entity A that has foreign_key_entity_B ?

Error: ORA-02292: integrity constraint (schema.FKA630D2FB5F0F1180) violated - child record found

Answer 1

Well most Oracle databases I've seen don't auto-delete child records or anything. So you should delete all child records before you can delete you parent record.