Error received when copying data from one table to another using char datatype with not null constraints"
"ORA-01400 - Cannot insert null."
Not Null - Constraint are used.
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy