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 list
We are on version 8.1.7.4 on the mainframe (OS390 platform)
-Original Message-
James Howerton
Sent: Tuesday, September 09, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
What version are you on???
There is a bug in 9.2.0.3, I was getting this error regularly on my
rman repositor
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 Message-
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 a
What version are you on???
There is a bug in 9.2.0.3, I was getting this error regularly on my
rman repository db when an rman resync was run. I've patched to 9.2.0.4
and the error has gone away.
...JIM...
>>> [EMAIL PROTECTED] 9/8/03 11:09:27 PM >>>
We are getting a strange deadlock problem and
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
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 DO_SET