OraFAQ Forum: Forms » how to display message from "raise application error " to forms

Home » Developer & Programmer » Forms » how to display message from "raise application error " to forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to display message from "raise application error " to forms [message #240784]

Fri, 25 May 2007 15:15

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

dear all
i'd like to asking if there is any way to display the message form raise application error from PL/Sql function or procedure to the forms
Ex.
i have procedure which a part of it to check if there is any data into table for specified customer
if yes i'm using raise application error to handel this check
i have button on a form to execute this proceduere , i'd like to display the message from raise application error when i click the button .

Report message to a moderator

Re: how to display message from "raise application error " to forms [message #240833 is a reply to message #240784]

Sat, 26 May 2007 05:40

sreepathi.das
Messages: 12
Registered: May 2007
Location: Cochin,Kerala

Junior Member

You can catch it in the on-error trigger of the form.
eg:-
procedure ****
---
raise application_error(-20001,'user exists');

on-error

if dbms_error_code = '-20001' then
message(sqlerrm);
end if;

Report message to a moderator

Re: how to display message from "raise application error " to forms [message #245097 is a reply to message #240833]

Fri, 15 June 2007 02:53

sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )

Senior Member

Did you get the solution?
Please tell me.

Report message to a moderator

Previous Topic:	Attaching files in forms (merged)
Next Topic:	Menu should be in the full path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 08:18:53 CDT 2025