How to Handle Forms Error in Triggers??

From: Aaron V <Tinkerist_at_hotmail.com>
Date: Tue, 15 Jul 2003 19:35:59 GMT
Message-ID: <zIYQa.59223$GL4.14604_at_rwcrnsc53>

[Quoted] [Quoted] I'm trying to handle an error in the Exception area of the code, but the it is a Forms error(FRM)
[Quoted] [Quoted] 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 Received on Tue Jul 15 2003 - 21:35:59 CEST