Re: How to Handle Forms Error in Triggers??

Aaron V wrote:

> I'm trying to handle an error in the Exception area of the code, but the it
> is a Forms error(FRM)
> not a DataBase error (ORA). Something to the effect of this...
>
> DECLARE
> bool_tf BOOLEAN;
> NO_LOV_DATA EXCEPTION;
> PRAGMA EXCEPTION_INIT(NO_LOV_DATA, -41830);
> BEGIN
> bool_tf := SHOW_LOV('LOV_DEPENDENTS');
> EXCEPTION
> WHEN NO_LOV_DATA THEN
> MESSAGE('No Data Returned For LOV',ACKNOWLEDGE);
> END;
>
> Is there a way to do something like this locally, without a ON-ERROR
> trigger??
> In this case I could pre-test the LOV by executing the same Select
> Statement,
> but in general, is there a way to handle FRM errors In the Same Code Block?
>
> Thanx,
>
> Aaron V

[Quoted] Other than using SHOW_ALERT ... what is wrong with your code?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)