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!

ERROR ORA-01400: cannot insert NULL

572137Dec 13 2007 — edited Mar 11 2010
Greetings:

I have looked throughout the forum and found that other people are getting this same error. however, I am getting it under another set of circumstances.

I have a page with form/report and in this form, I have a submit set on a field with the javascript behavior onBlur. This submit brings me back values for a form (IE I look for Social Security Number and it brings me back the employee name and employee number). This information is part of a bigger form that has other fields that are submitted with a button. When I submit the main form with a button, the page complains that there is no value set for Social security number (not the key field, as I have setup a trigger with a sequence for that) even when I have clearly input the value myself. What could be wrong here?

Thanks for your support. .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2010
Added on Dec 13 2007
14 comments
9,402 views