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
gbardet
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)

Report message to a moderator

Re: Trap all errors in forms [message #225407 is a reply to message #222815] Mon, 19 March 2007 22:03 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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.

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 00:33:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.