Re: Oracle does not rollback correctly after ENABLE CONSTRAINT failed

uhaham_at_gmail.com wrote:
> Now I understand the strange behavior of Oracle.
> I'm writing application that should work with several DBMS (MS SQL ,
> Oracle and DB2). Only Oracle behavie this way.
> I will need to redesign this part, John suggestion sound resnable even
> that I have a lot of dependencies and I hoped the db server will do
> the checking, as it done in other DBMS.
>
> Thanks a lot.
>

SQL Server <> Oracle <> DB2

Each of the above all behave differently, *especially* when it comes to transactions. It is no surprise that a transaction is handled differently in one RDBMS compared to another.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown