Oracle database does not permit empty string insertion into ofGroupProp

Description

This Problem still exists in oracle 11.2.0.2.

The reason ist, that oracle saves empty Strings as NULL so the NOT NULL constraint on the column PROPVALUE is violated.

It can be fixed with:

ALTER TABLE ofGroupProp MODIFY propValue VARCHAR2(4000) NULL;

Environment

None
Fixed

Assignee

Guus der Kinderen

Reporter

Daryl Herzmann