A m Z o n e

The other deadlock ORA-4020

Why does the Oracle error ORA-4020 occur?

ORA-04020: deadlock detected while trying to lock object

Create a procedure A and call procedure B in it. Create the procedure B and call procedure A in it. Run anyone of the routines. It will result in ORA-4020 after some time. This error had to be reported to Oracle support in earlier versions of oracle. Now in 8i, it throws the deadlock error. Recursive calls are supported when both the routines are part of a package.

Press the Back button of you Browser to go to previous page
Home