Error: "ORA-01400 - Cannot insert null" when data is copied to a schema with NOT NULL CHAR. (14685)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Error: "ORA-01400 - Cannot insert null" when data is copied to a schema with NOT NULL CHAR.
Description

Error received when copying data from one table to another using char datatype with not null constraints"

"ORA-01400 - Cannot insert null."
Cause

Not Null - Constraint are used.
Resolution

WORKAROUND:

1. Select View | Options | Data Grids | Visual | Display | set Null columns to Blank.
2. Select View | Options | Data Grids | Data | Display | uncheck Trim string data.

NOTE: The above workaround works with Varchar2 datatype.

STATUS:

Waiting for fix in a future release of Toad for Oracle.
Defect ID

QCM# 28593

Feedback submitted.

Was this article helpful?

[Select Rating]

Title