ORA-04061 handling
ShuraOct 1 2008 — edited Oct 10 2008Hi everybody.
I need an advice how to handle 'state of packages' error inside pl/sql code.
Actually I have a package header "A" with declaration like 'ITEM_SERVICE CONSTANT NUMBER := 1;' and a package "B" calling package "A".
Then I want to replace the package body "A". Note it's actually stateless, the constant is defined in the header. But when I try to write a handler in the package body "B" like 'WHEN OTHERS THEN NULL;' I am starting to get ORA-04061 in all subsequent calls until I don't pass this error to application level. Is it possible to override this behavior in order to do not notify calling application about this error but just retry instead when you exactly know the error can be suppressed?
Thank you.