AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About 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
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > date in forms

Oracle - date in forms


Expert: Suchitra Joshi - 10/9/2009

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

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.