Formsbuilders and his annoying messages

[mike778]

I run exec_query from formsbuilder.
when he doesnt find anything he always writes:
FRM-40350: Query caused no records to be retrieved.

But, I don't want him to do that, instead he should write nothing. has anybody an idea how to make him shut up?

thanks,

greetings, Michael

 

[sem]

Try to catch it in on-message trigger.

Regards, Dima

 

[mike778]

I tried this "on message" trigger:

DECLARE
lv_errcod NUMBER := MESSAGE_CODE;

BEGIN
IF lv_errcod = 40350 THEN
null;
end if;
END;

but doesnt work :-(.

 

[sem]

1. You should process other message codes also or you may miss something important;
2. Both 40301 and 40350 have about the same meaning, so you should catch both;
3. Check whether there's no other ON-MESSAGE triggers defined on the lower level.

Regards, Dima

 

[mike778]

oh, you where right with the lower level, thank you.

greetings, mike