Home » ADF » ORA-02292: Integrity Constraint
ORA-02292: Integrity Constraint

ORA-02292: Integrity Constraint

 

 

Sometimes user need to change foreign key attribute value in ADF table’s master detail relationship. If you try to change master table’s foreign key value, you’ll  get the following integrity constraint error message.

ORA-02292: integrity constraint (JAGRANDB.SYS_C00162401) violated – child record found

 

Download Sample Code

 

To resolve this issue, if user want to change a foreign key attribute in master table, then child table attribute’s value should also change consequently.

ADF has predefined features for this requirement.

  1. Go to Master Detail Association.
  2. In Behavior tab under relationship, check composition association.
  3. Then check “Cascade update key attributes”.

 

1

 

 

Output: –  This will result the following. When we change the department id in master table, then on child table department id automatically gets changed.

2

 

 

 

About Manish Pandey

Manish Pandey is a Senior Developer with more than 3 years of experience in JAVA Programming. Currently enhancing skills in ADF.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>