java.sql.SQLException: ORA-02291: integrity constraint

January 5, 2009

One of the most unusual and frustrating error of Oracle database. May happen because of no reference of a column in a table. Suppose you refer a column ca of table a for a column cb of table b. Your table definition is as like

foreign key (ca) references b(cb)

When you want to insert data on table a with such value for column ca with value that doesn’t exits in column cb of table b. You are just identified to have such error message.

by: Md. Shahjalal


Follow

Get every new post delivered to your Inbox.