Home » Developer & Programmer » Forms » form message
form message [message #237329] Mon, 14 May 2007 03:05 Go to next message
u263066
Messages: 47
Registered: March 2007
Member
there is one procedure in the database, I need to call this procedure from some button in the form.

There is some debug message written in the procedure,since earlier it was called by database end only.

Is there any way to retrive the message from procedure and syconize with form message,
Re: form message [message #237477 is a reply to message #237329] Mon, 14 May 2007 11:02 Go to previous message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
You can trap the messages that comes from the database in a on-error trigger at for level. You can catch any type of messages like constraints failure or primary key failure. It will even give you the name of the constraint that failed so you can even display a specifi message for each constraint on you table.


To be able to display your message in form, you need to raise your error using something like raise application error...
Previous Topic: how to view entire value of clob datatype in forms 6i
Next Topic: Triggers problem in forms6i
Goto Forum:
  


Current Time: Fri Dec 02 18:43:08 CST 2016

Total time taken to generate the page: 0.31925 seconds