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.

Report message to a moderator

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: 21818
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.

Report message to a moderator

Previous Topic: Form to Database connection Problem
Next Topic: custom form FRM-92100
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:50:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.