Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04061 handling

ShuraOct 1 2008 — edited Oct 10 2008
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2008
Added on Oct 1 2008
13 comments
821 views