wrong reference when inserting
we are experiencing a weird case:
there are two schemas: A and B
both contains same pair of parent-child tables: Parent and Child, and the fk constraint have the same name for both schemas (A.fk and B.fk)
Sometimes when user A tries to insert into Child table and error rises :
ORA-02291: integrity constraint
and the error refers to B.fk whern the correct fk is A.fk
Does any one have had this kind of problem ??
tks