Problems with deadlocks?
Hi,
We have a problem with deadlocks in a Oracle 9.2.0.6 database. I have looked in several trc-file and mostly it looks like this
DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE T_WO_WORKORDER SET BLEND = TO_CHAR(:B2 ) WHERE ORDERNO = :B1
----- PL/SQL Call Stack -----
object line object
handle number name
42AB3B44 62 procedure GSS2_USAWES_DBO.P_WO_SETPRESSDATABLEND
44AFD1E8 1 anonymous block
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
0