Home » Developer & Programmer » Forms » problem in working with on_error trigger (Oracle 10g forms)
problem in working with on_error trigger [message #331183] Wed, 02 July 2008 08:46 Go to next message
Messages: 62
Registered: April 2006
Location: United States, MI
Hi Friends,
I have developed an application in which I have used the on_error trigger to capture the error
. I have used this trigger so that no duplicate values can be inserted. When running the form it works fine. Now suppose I am inserting a duplicate record it is alreting that I cannot insert a duplicate value in the field.
Once this message is displayed I am making the entries made into that particular fields ( that particular entire record empty).
So the user needs to enter a new record. Suppose the user does not wish to enter a new reord at this point and wishes only to move across the various records being displayed then he should be able to do that.

But in my form I am unable to do that and the error I am getting is

ELSE:FRM-40202:Field must be entered

This might be due to the else part I have used in on_error trigger.

Is there any way such that a user can use clear_record in on_error trigger so that the user can go to previous and next records once he gets the error message when he tries to insert the duplicate record.

It would also be helpful if you can provide me the code snippets if possible. Please let me know if you have any other questions in order to help me in working out this problem.

Thanks and regards,
Vamsi K Gummadi
Re: problem in working with on_error trigger [message #338154 is a reply to message #331183] Mon, 04 August 2008 00:43 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Consider deleting the record instead of emptying it.

Previous Topic: Closing Entire Application
Next Topic: FRM-40508 : ORACLE error: unable to INSERT record
Goto Forum:

Current Time: Fri Oct 21 13:49:49 CDT 2016

Total time taken to generate the page: 0.13473 seconds