1 Reply Latest reply: Feb 20, 2013 2:45 PM by Damir Vadas RSS

    ORA-00060 Deadlock after 2 page process

    TobiP
      Greetings to the community,

      On one 4.2 JQM page I have two processes, 1. Automatic Row Processing (DML), 2. PL/SQL anonymous block, which runs on insert in the 1. process, calls a stored procedure and writes data in another link table (amongst them the pk).

      Now when I run each process individually (the other deactivated) it works. But when I run both, I get the Deadlock error. Our DBA said, there are too many requests running at the same time. How can this be?

      I could put both processes into on procedure, coding the automatic part myself, but there should be another solution.

      Thanks for any advise,
      with best regards,
      tobi

      edit:
      I should mention: the anonymous block calls a stored procedure.
      Because when I have the 2nd process not executed via a stored procedure but in the apex window, its working.

      Edited by: TobiP on 19.02.2013 07:59