Answer Detail: RE: Actions SQL and Call Section in AE

GeekInterview.com > Interview Questions > Peoplesoft

Print |

Question: Actions SQL and Call Section in AE

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

February 02, 2008 02:10:50	#1
UshaD	Member Since: February 2008 Total Comments: 1
RE: Actions SQL and Call Section in AE
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.

Back To Question