Home » Developer & Programmer » Forms » how to display message from "raise application error " to forms
how to display message from "raise application error " to forms [message #240784] Fri, 25 May 2007 15:15 Go to next message
RAY_HT
Messages: 153
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 .

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 Go to previous messageGo to next message
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;
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 Go to previous message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Did you get the solution?
Please tell me.
Previous Topic: Attaching files in forms (merged)
Next Topic: Menu should be in the full path
Goto Forum:
  


Current Time: Thu Dec 08 02:04:14 CST 2016

Total time taken to generate the page: 0.08787 seconds