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

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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: 21823
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;

Report message to a moderator

Previous Topic: error handle
Next Topic: how to manage many list items in forms 6i?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 02:16:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.