Re: 10.1 / 10.2: different trigger behaviour

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 22 Jan 2007 20:04:14 +0100
Message-ID: <ep31r7$u4i$1@news5.zwoll1.ov.home.nl>

Tarby777 schreef:

>> Posting the actual error message and possibly the trigger code would
>> make it possible for someone to help you.

>
> OK, thanks. Here's the error:
>
> 716 rows created.
> commit
> *
> ERROR at line 1:
> ORA-02091: transaction rolled back
> ORA-02291: integrity constraint (CHS.LIBRARYCONNECTOR_FK) violated -
> parent key not found
>

[snip!]

Can you check what this constraint does - which fields are involved?

>> constraints are deferrable on 1, not so on release 2

>

>> your data is not the same; you overlooked something.

>
> I don't think that either of these are possible in the test that I'm
> doing. I start out with a new user that has no schema whatsoever, and I
> load a dump file into it, giving me the schema and the data. However,
> to double-check, I ran a schema comparison utility between the r1 and
> r2 schemas before running the script, and it reported no differences.

Would it have picked differences in DATA? That is what I was suggesting.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Mon Jan 22 2007 - 13:04:14 CST