Babette,
Could you post the deadlock trace file please.
Henry
-Original Message-
Babette Turner-Underwood
Sent: Tuesday, September 09, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L
We are getting a strange deadlock problem and I am having trouble
understanding the cause and
It is at work. I will bring it home (on floppy) and post it tomorrow.
-Original Message-
Henry Poras
Sent: Tuesday, September 09, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
transaction
Babette,
Could you post the deadlock trace file please.
Henry
-Original
Yes we have a commit in the procedure and we rollback if an exception is
raised. That was one of the first things I looked at. It would have been
nice if that was the only problem.
- Babette
-Original Message-
Ryan
Sent: Tuesday, September 09, 2003 12:29 AM
To: Multiple recipients of
We are getting a strange deadlock problem and I am having trouble
understanding the cause and action. Metalink has not been too useful for
this one.
We have a procedure eg INS_REC that does an insert into table ABC. The
procedure uses a pragma autonomous transaction.
We have a package eg
are you committing in the procedure with the autonomous transaction? do you
have an exception block with a rollback?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 12:09 AM
We are getting a strange deadlock problem and