Sunday, May 18, 2008

JDev/ADF sample - LOV in Create Form with Mandatory Fields

    Download - LOV11Create.zip

4 comments:

Ricardo said...

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

Andrejus Baranovskis said...

Hi,

May be you didnt created trigger in database?

Regards,
Andrejus

tareq alawneh said...

dear
how to create this trigger
regards

Andrejus Baranovskis said...

For example, check here: http://www.razorsql.com/features/oracle_add_sequence_trigger.html

Andrejus