How to trap the FRM-47017 error ?
67656Dec 12 2008 — edited Dec 17 2008Hi 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!