Using Oracle connections a data compare is performed between two tables. Tables have a CHAR column, with source table having four blank spaces in one record in this field. Target table having a primary key on this field. Data Compare generates a sync script having an Insert statement for this record with '' (no spaces) value. Whereas this should be an Insert statement with four spaces value.
When running the generated sync script the following error occurs:
"ORA-01400: cannot insert NULL into ("<schema>"."<table>"."<column>")"
Also, when executing a simple Select from source table, and exporting its results to SQL Script, Toad generates Insert statement again with have no spaces for this record.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad Data Point.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center