Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

null exception on inserting in OEHR_EMPLOYEE table of OEHR_EMPLOYEES

688723Jan 23 2011 — edited Jan 23 2011
Hi,

I have imported OEHR sample schema. When i am creating a new employee record from a tabular form, '*empno*' column is read only, having null value. And on clicking submit, i am getting the below exception. Can anyone help me with this?

Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-01400: cannot insert NULL into ("SCHEMA_A"."OEHR_EMPLOYEES"."EMPLOYEE_ID"), insert into "MYSCHEMA_PC"."OEHR_EMPLOYEES" ( "EMPLOYEE_ID", "FIRST_NAME", "LAST_NAME", "EMAIL", "MANAGER_ID", "HIRE_DATE", "JOB_ID", "DEPARTMENT_ID", "SALARY", "COMMISSION_PCT", "PHONE_NUMBER") values ( :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2011
Added on Jan 23 2011
2 comments
187 views