Peoplesoft Interview Question:

If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?

Submitted by: Administrator

When a SQL is run, there is a lock on the table by the database until that section is completed. If during that time there runs some other process, which will use the same table locked by our section using call section, this process will fail.
Submitted by: Administrator