Very often we see background jobs in status ERROR with the message “...object is locked by another user.“.
How can I handle this in my PLSQL procedure?
There is a lock_sys package and oracle has a v$lock table.
The lock_sys takes lock_name_ as a parameter. I don’t know what that is.
The second includes an ADDR column. I don’t know what that refers to.
Can any of this be used to handle this error, by fx postpone the execution of the job if the object is locked?
Best answer by Tomas RuderfeltView original