insert blank or white space but not null
407048May 3 2004 — edited May 3 2004By necessity (part of a aggregate PK) we have a column in the database that is defined as NOT NULL. We just found out that it is desirable to allow the insertion of empty strings in that column. In Java the empty string is treated differently than a null. But Oracle appears to treat the empty string and NULL synonymously. Thus we get Oracle errors like ORA-01400: cannot insert NULL into ....
Does Oracle have a way or an Oracle function to make Oracle accept an empty string - short of changing the attributes for that column or inserting white space ??
Any ideas ?