Home » Developer & Programmer » Forms » Trap all errors in forms
icon4.gif  Trap all errors in forms [message #222815] Tue, 06 March 2007 08:19 Go to next message
Messages: 3
Registered: March 2007
Junior Member
I am using Oracle forms 10g. the validation unit of my form is set to form level.
I want to validate data when I commit the form. If they are errors in several text items I'd like to trap all the errors at the same time and their origin in a data structure like RecordGroup or PL/SQL tables. Can somebody tell me how I can identify the text field(s) that produce the error. Is there any built-in I can use to identify that for example : textfeld1 is malformed , textfield2 invalid number .....
example: I have 3 text fields: one for date and the two others for number but If I put an invalid date and two invalid number when I commit my form I want to trap three errors (not the first one that forms encountered).
I use a on-error trigger but I trap only one error (the first one that form found)

Re: Trap all errors in forms [message #225407 is a reply to message #222815] Mon, 19 March 2007 22:03 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you found a solution?

I don't believe that it is possible to get 'all three' at once. Basically, Oracle stops at the first runtime error because it has no or little idea as to where it should go after this happens.

Previous Topic: Forms configuration issue - resolved
Next Topic: please help ORA-01026: multiple buffers of size > 4000 in the bind list
Goto Forum:

Current Time: Wed Mar 01 14:13:22 CST 2017

Total time taken to generate the page: 0.16200 seconds