- LOV in Create Form with Mandatory Fields. One more reason why Oracle Rocks Again - JDeveloper 11g TP4, its a solved issue with LOV fields in Create form that contains mandatory fields. I have documented this issue some time ago on OTN. Also I have described it in my previous post with sample application - Hints for List-Of-Values (LOV) in JDeveloper 11g TP3. The main problem was, that it was impossible to use LOV in Create form with even one or several not associated mandatory fields - validation errors were shown when value was selected in LOV window. Actually, similar problem was in JDeveloper 10.1.3.x also, but now it is solved.
- Download - LOV11Create.zip
4 comments:
I am getting the following error when trying to create a new employee: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO EMPLOYEES(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,DEPARTMENT_ID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9) RETURNING EMPLOYEE_ID INTO :10; END;".
Error
ORA-01400: cannot insert NULL into ("HR"."EMPLOYEES"."EMPLOYEE_ID") ORA-06512: at line 1
I have verified that a DB Sequencer called EMPLOYEES_SEQ does exist in the DB
Hi,
May be you didnt created trigger in database?
Regards,
Andrejus
dear
how to create this trigger
regards
For example, check here: http://www.razorsql.com/features/oracle_add_sequence_trigger.html
Andrejus
Post a Comment