How can i get rid of messages in runtime

[LimonaM]

I'm anoyed of one message in runtime. What can i do so the message wouldn't appear? I use on-message trigger:

DECLARE
errnum NUMBER := ERROR_CODE;
BEGIN
IF errnum = 40401 THEN
:GLOBAL.chk := 'y';
END IF;
END;

but it doesn't help in this case! Is there some other solution?

 

[Bimalaggarwal]

Where are you trying to do this ? In pl/sql code ? Oracle forms ?

In the meantime, try something like :

DECLARE
errnum NUMBER := ERROR_CODE;
BEGIN
IF errnum = 40401 THEN
raise;
END IF;
exception when others
if errnum = 40401 then null;
else raise;
end if;
END;

 

[sfvb]

You can set the :system.message_level := '20' before the operation that is causing the message, then restore it after the operation is over.