SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Any function to check referential integrity in Oracle DB?

xarg-XrcAug 29 2012 — edited Aug 29 2012

Hi All,

I have a primary that is referenced in at least 7 other tables (out of 15) as foreign key. When I try to delete an entry I get referential integrity constraint violation error as expected when I create an entry and use the primary key as foreign key in one of those 7 tables.

Is there a built in function in Oracle database that allows you to check referential integrity? I need it for my application so I can run this check and do my delete if its ok to do so else show a nice error message saying the its not possible to delete.

Thanks,

Using Oracle Database 11G (XE) Windows.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 26 2012

Added on Aug 29 2012

7 comments

1,393 views