Sunday, May 18, 2008

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

    Download - LOV11Create.zip

4 comments:

Unknown 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

Andrej Baranovskij said...

Hi,

May be you didnt created trigger in database?

Regards,
Andrejus

Unknown said...

dear
how to create this trigger
regards

Andrej Baranovskij said...

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

Andrejus