amar on web

• home
• On Oracle database
• On Oracle Forms&Reports
• On Oracle iAS
• On linux
• On PMP certification
• My blog
• My Profile
• family link

The other deadlock ORA-4020

Why does the Oracle error ORA-4020 occur?

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.

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was create on 15-dec-2000 and last updated on 15-dec-2000.
please forward all queries to amar_padhi@fastmail.fm