User running Data Compare for source table in SQL Server database and target table in Oracle. Goal is to insert data from SQL Server table to Oracle table. Oracle table has NCLOB column that is inserted with SQL Server NVARCHAR(MAX) data.
When running the synchronization script generated by compare the following error occurs:
"Message: ORA-21560: argument 2 is null, invalid, or out of range"
Package call "dbms_lob.write package" in script has an invalid Amount (this is the second parameter in package call) value.
WORKAROUND:
Modify script to change second parameter of dbms_lob.write package call to "length(line)".
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