Q: Why do I get an "ORA-01400: Cannot insert NULL into column name" when inserting a blank string?
A: This is a known Oracle issue. When inserting or updating a value for a varchar2, if you try to insert an empty string (""), Oracle interprets the value as NULL. If there is a NOT NULL restriction on the column in which you are inserting the value, the database throws the ORA-01400 error.
Moppelkotze 
