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

NickDK · Accepted Answer · 2009-11-02 09:08:22Z

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.

answered Nov 2, 2009 at 9:08

NickDK

5,2072 gold badges21 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

cometta Over a year ago

smart you know i'm using oracle =) mean no workaround other than manually delete child

NickDK Over a year ago

Well you could always look into cascade delete as a workaround but I don't really have alot any experience with it myself but I think it should be used with caution, any mistakes could result in unwanted data loss ;-)

Collectives™ on Stack Overflow

delete entity that map with another entity

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related