This discussion is archived
1 Reply Latest reply: Feb 20, 2013 12:45 PM by Damir Vadas RSS

ORA-00060 Deadlock after 2 page process

TobiP Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points