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.
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
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.
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.