Re: FRM-50009

Hi,
You're trying to raise an exception within an exception. Not possible. The when others will NOT get executed because of an error in one of the other exception handling conditions. Rethink your approach and remember to level your exceptions - they are passed up only, they never get passed on the SAME level they came from.

• Peter H. Larsen Oracle Consultant

Markku Heikkilä wrote:
>
> I'm using integer type in text item. Users should
> onlly be able to insert integer values. This works
> fine, but when I try to use my own error handling
> it seems that it dont respond to frm-50009 at all.
>
> below is my exception code...
>
> exception when VALUE_ERROR then
> Begin
> alert_n:=SHOW_ALERT('alert_integer');
> Raise form_trigger_failure;
> end;
> when others then
> begin
> Message(errtyp||'-'||TO_CHAR(errnum)||':
> '||errtxt);
> RAISE Form_Trigger_Failure;
> end;
> end;
>
> Neither value_error or others wont' be execuded to
> error FRM-50009...
> So what Am I doing wrong
>
> Greetings from Finland
> Markku Heikkila

-- 

Peter H. Larsen, Oracle and Applications specialist
Dynamic Resources Inc, Alexandria
Phone: 703-914-9800  #103
Fax: 703-914-9804
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my
employer.