You are here:

Oracle/date in forms

Advertisement


Question
In my form there is 3 field 1)header_id 2)so_date 3) description
here header_id is a disabled feild and value is entered using a sequence in pre insert trigger
when I enter values into these fields i am getting error as disabled item header_id failed validation
if date field is removed I am not getting this error

Answer
Hi Anu,

I will require more details for this -

1) Is date field required field ? If yes, are you entering values? What format ? Any triggers on date field?
2) What are the corresponding triggers in forms like pre-insert (along with the code in the trigger)?
3) The exact error message and from which trigger it is displayed. Code for that particular trigger.

Please send these details so that I can help you further.

Regards

Suchitra

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2012 About.com, a part of The New York Times Company. All rights reserved.