Skip to Main Content

Oracle Forms

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!

How to trap the FRM-47017 error ?

67656Dec 12 2008 — edited Dec 17 2008
Hi all,

I need to delete a parameter ('branch code') from a parameter list, but this parameter is not always in the list.
I come to the problem that, if the branch code is not in the list and I try to delete it, the FRM-47017 error will popup. I need to suppress this error message.

I try to use exception to trap the error as follows , but not succeed :

begin
delete_parameter(pl_id, 'BRANCH_CODE')
exception
when others then
null;
end;

Also, I try to set the SYSTEM.MESSAGE_LEVEL, still with no luck.


Now I use the ON-ERROR to handle the error, but I have 150 forms that will do the same thing, how can I avoid adding 150 ON-ERROR triggers but still can suppress the error ?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2009
Added on Dec 12 2008
5 comments
1,118 views