Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Jim.

Asked: June 14, 2002 - 4:42 pm UTC

Last updated: November 24, 2008 - 7:40 pm UTC

Version: 9.0.1

Viewed 10K+ times! This question is

You Asked

Hi Tom,

Could you provide an explanation as to what this error is trying to tell me. The error messages manual says "Cause: The application tried to commit a transaction and the server rolled it back." and
"Action: No action required" is kind of vague. Why would a transaction be rolled back with this message?

TIA

and Tom said...

It is a message you would get with a global transaction for example.

You can start a transaction (a "named" transaction) and have other sessions join it and participate in it. If one of the sessions rolls it back however, and another session tries to use it -- they'll get "ora-24761", the transaction was rolled back.

see
</code> http://docs.oracle.com/cd/A87860_01/doc/appdev.817/a76975/oci08sca.htm#425180 <code>

you can get a similar message with deferrable constraints:

ops$tkyte@ORA9I.WORLD> create table t ( x int, constraint check_x check ( x > 0 ) deferrable initially deferred );

Table created.

ops$tkyte@ORA9I.WORLD>
ops$tkyte@ORA9I.WORLD> insert into t values ( -1 );

1 row created.

ops$tkyte@ORA9I.WORLD>
ops$tkyte@ORA9I.WORLD> commit;
commit
*
ERROR at line 1:
ORA-02091: transaction rolled back
ORA-02290: check constraint (OPS$TKYTE.CHECK_X) violated


as well....

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Same Error

Js, November 01, 2004 - 5:55 am UTC

Hi ..

We are facing this error.
We are using .NET as Front End.

1. Selecting/Generating a dataset (.net) from table - Serialnumber
2. Based on some columns we updating 3 - 4 tables
3. Updating back the same table and same record in Serialnumber generates this error.

Pls. tell us solution.





Tom Kyte
November 01, 2004 - 1:23 pm UTC

please tell us the problem?

ORA-24761

A Reade, November 01, 2004 - 11:16 pm UTC

Ok Sir ...

We are facing ora-24761 while updating a table.

We have a front-end application ( .NET ). End user open a dataset ( Recordset ). After updating other tables when
he tries to update the same tables he gets ORA-24761.

He is able to update less than 100 records but if tries
bulk updating then ORA-24761

Thanks

Tom Kyte
November 02, 2004 - 7:25 am UTC

sorry, i know absolutely less than nothing about .nyet. it won't run on any of my computers.

I'll have to refer you to support on this one. No ideas what the MS stuff is doing under the covers.

ORA-24761

Jim, November 02, 2004 - 1:28 pm UTC

I was getting this error in a .NET/Oracle Services for MTS/MS DTC environment. Basically COM+ timing out generated the ORA-24761. Increasing the limit solved the problem.

GoodLevitation

Soe Naing, November 24, 2008 - 3:06 pm UTC

In our .Net application using CSLA framework, I'm using "TransactionalTypes.TransactionScope" attribute, and I don't think this works well with Oracle. For me, I just took out this line of code from my DataPortal_Update method, and all works.

However, if you need to use it, use "autonomous transaction" in your procedures.
Tom Kyte
November 24, 2008 - 7:40 pm UTC

oh my gosh.

DO NOT USE AUTONOMOUS TRANSACTIONS in general, they would be an very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very rare thing.


Better to understand what is happening (transactions are just about the most important thing in database processing after all) and correct it.

If your framework doesn't work - it isn't much of a foundation to build your applications on is it.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.