ora-00060 deadlock
Hello
I get deadlock ora-00060
I have 2 concurent statement in trace
current SQL:
UPDATE XX_PERSON SET TITLEBEFORE=:B9 , NAME1=:B8 , INITIALS=:B7 , NAME2=:B6 , TITLEAFTER=:B5 , IDENTDATA1=:B4 , IDENTDATA2=:B3 , IDENTDATA3=:B2 , ISOPERATOR='Y' WHERE IDPERSON=:B1
and
UPDATE XX_PERSON SET FA_PERSIBIN = :B2 WHERE IDPERSON = :B1
so i find pl/sql block with problem
FOR j IN (SELECT p.idperson, pi.idpersonidentification
FROM xx_personidentification pi, xx_person p
WHERE pi.ididentificationtype=xx_core_parameters_pkg.ID_IT_PASSWORD
AND UPPER(pi.username)=UPPER(i.code)
AND pi.idperson=p.idperson
ORDER BY DECODE(xx_secure_oper_pkg.GetRecordWeight(pi.valid, pi.validfrom, pi.validto), 0, 1, 2)) LOOP