PL/SQL (MOSC)

MOSC Banner

ora-00060 deadlock

edited Oct 18, 2019 5:04AM in PL/SQL (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center