Re: How to suppress the message on run time forms 6i

From: Pizza Goldberg <pizzagoldberg_at_hotmail.com>
Date: Fri, 2 Jan 2004 10:50:07 -0500
Message-ID: <XbSdnYCSae1QD2iiRVn-tw@comcast.com>

"David" <dt_146_at_yahoo.co.in> wrote in message news:d5840ebd.0401010235.3d981d73_at_posting.google.com...
> Hi,
>
>
> I am using forms 6i and got the following message on run time. How do
> I suppress this message on run time? I don't know the message code of
> this message, may be it is the prompt or some other type of message.
>
> However I also used the system variable MESSAGE_LEVEL to suppress this
> message but it did not suppress.
>
> For Example:
> :SYSTEM.MESSAGE_LEVEL := '25';
>
> Please send the code to suppress this message.
>
> FORM MESSAGE:
>
> Oracle Forms 6.0
>
> Use the Windows Program Manager to execute operating system
> commands.
>
>
>
>
>
> Thanks
>
> David

Just create an ON_ERROR trigger on the form level...use these exact names for built-ins I have below (suggest you paste in what I put below and modify). You can handle what you want in the specific ways you want, everything not "handled" in this trigger will be treated the same way as a normal error.

Enjoy the new year.
Pizza

DECLARE

   lv_errcod  NUMBER       := ERROR_CODE;
   lv_errtyp  VARCHAR2(3)  := ERROR_TYPE;
   lv_errtxt  VARCHAR2(80) := ERROR_TEXT;

BEGIN
   IF (lv_errcod = 40401) THEN

   null; --this means it will be ignored

   --ELSIF (lv_errcod = 40mmm) THEN
   /*

• More tasks here */

--ELSIF (lv_errcod = 40zzz) THEN

   /*

• More tasks here */ ELSE Message(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt); RAISE Form_Trigger_Failure; END IF; END;

Received on Fri Jan 02 2004 - 09:50:07 CST