Home » Developer & Programmer » Forms » Not able to display error raised by RAISE_APPLICATION_ERROR from oracle
Not able to display error raised by RAISE_APPLICATION_ERROR from oracle [message #406513] Thu, 04 June 2009 06:29 Go to next message
prasi
Messages: 1
Registered: June 2009
Location: Nepal
Junior Member
i am using oracle forms 10g with 10g database.i am running the forms through application server 10g.

i am trying to migrate from forms 6i to Oracle forms 10g which runs in IE.

i have a procedure written in database which raises a user defined exception using RAISE_APPLICATION_ERROR like

RAISE_APPLICATION_ERROR(-20013,'Please enter year BETWEEN '||TO_CHAR(vminyear)||' AND '||TO_CHAR(vmaxyear));

i have called this procedure from WHEN_VALIDATE_ITEM Trigger.

i am trying to display this message in IE.

for this i have used ON_ERROR trigger in forms but the message does not appear.

when running the form

this process works fine in forms 6i.but doesnot in 10g.

please help me.


Re: Not able to display error raised by RAISE_APPLICATION_ERROR from oracle [message #406519 is a reply to message #406513] Thu, 04 June 2009 06:52 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you omit the ON-ERROR trigger?

Just as any other (built-in) Oracle error (no data found, to many rows, dup val on index, etc.) doesn't need the ON-ERROR trigger, your exception would be raised the same way.
Previous Topic: Form to Database connection Problem
Next Topic: custom form FRM-92100
Goto Forum:
  


Current Time: Wed Dec 07 12:21:17 CST 2016

Total time taken to generate the page: 0.11197 seconds