Home » Developer & Programmer » Forms » How to trap this error FRM-40350
How to trap this error FRM-40350 [message #275929] Tue, 23 October 2007 07:04 Go to next message
ShaShalini
Messages: 59
Registered: January 2007
Member

Hi

When I query a block and no record are retrieved , I want to show an alert with a personalised message .

Can anybody tell me how to do it .
I tried putting the error code in On-Error and On-message trigger but it does not work .

I am using oracle 10G.

Thanks
Re: How to trap this error FRM-40350 [message #276081 is a reply to message #275929] Tue, 23 October 2007 19:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'on-error' and 'on-message'.

Please post your code so that we can see what you HAVE tried to do.

David
Re: How to trap this error FRM-40350 [message #276105 is a reply to message #276081] Wed, 24 October 2007 00:29 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that you are on the right path; what might have distracted you from it is written in the topic title: "ERROR 40350" - it is not an error, it is a MESSAGE.

So, using such a code might help:
-- ON-MESSAGE block level trigger

if message_code = 40350 then
   message('Your message text here');
end if;
Previous Topic: error handle
Next Topic: how to manage many list items in forms 6i?
Goto Forum:
  


Current Time: Sat Dec 10 22:28:23 CST 2016

Total time taken to generate the page: 0.08838 seconds