ORA-02292: integrity constraint violated happend while inserting record
875785Mar 27 2013 — edited Mar 27 2013Hi;
Our oracle version is “Oracle Database 10g Release 10.2.0.5.0 - 64bit”. We developed our application with Odp.Net but problem is not related to Application side.
Table A has 2 constraints:
1. ID_PRM : Primary key constraints
2. TableC_ID_FK : Foreign key constraints to Table C. Referencing the Table C’s Primary key column.
Table B has 2 constraints:
1. ID_PRM : Primary key constraints
2. FKCF9D7D47C3FD369A : Foreign key constraints to Table A (Tablet that we are inserting data). Referencing to Table A’s Primary key column.
We had an exception thrown while inserting new records to table A. We are sure about this, it was happend while inserting new records. Exception detail is:
+Oracle.DataAccess.Client.OracleException ORA-02292: integrity constraint ([Schema].FKCF9D7D47C3FD369A) violated - child record found at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at+
When we looked the ([Schema].FKCF9D7D47C3FD369A) the constriant from user_constraints, it is at table B ! How could this exception happen?
Can anyone understand why this happend?
Best regards.