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

Activity

Show:
Fixed
Created August 7, 2019 at 3:29 PM
Updated October 28, 2020 at 1:26 PM
Resolved August 7, 2019 at 7:43 PM

Flag notifications