DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
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:
Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TM-0000b3b4-00000000       191     508    SX            187     439    SS   SSX
TX-00090026-000d336c       187     439     X            191     508           S
session 508: DID 0001-00BF-00000AAA     session 439: DID 0001-00BB-00000C27
session 439: DID 0001-00BB-00000C27     session 508: DID 0001-00BF-00000AAA
Rows waited on:
Session 439: no row
Session 508: obj - rowid = 0000B358 - AAALNYAA1AAAVdwAAA
  (dictionary objn - 45912, file - 53, block - 87920, slot - 0)
Information on the OTHER waiting sessions:
Session 439:
  pid=187 serial=7471 audsid=1112381186 user: 156/PROGVERKPROC
  O/S info: user: was, term: unknown, ospid: , machine: svlipc36
            program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=2546894660
  Current SQL Statement:
  DELETE FROM REFERENTIE_EXPRESSIE WHERE PROGNOSEKANAAL_CODE = :B2 AND REFERENTIE_EXPRESSIE_CODE = :B1
End of information on OTHER waiting sessions.
Current SQL statement for this session:
INSERT INTO FUNCTIE_DATUM_TERMIJN_U_EXPRE (PROGNOSEKANAAL_CODE, FUNCTIE_TYPE_CODE, PROGNOSE_ELEMENT_CODE, INVOER_DATUM, REFERENTIE_EXPRESSIE_CODE, LAST_UPDATED_DATE, AUTO_CALCULATED) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE, 'N')