Devart Forums

Hi,
I am trying your new tool and i found a problem.
If record in the source database contain a quote the script is not generating a double quote. So this result in the error
ORA-01756: quoted string not properly terminated
and
ORA-00917: missing comma

Ex:
INSERT INTO SNA.CNVRO_PLI_SQL(MODULE, NO_LIGNE, LIGNE)
VALUES (NULL, 100, ' PUT EDIT('-----------------')(SKIP ,A);');

should be
INSERT INTO SNA.CNVRO_PLI_SQL(MODULE, NO_LIGNE, LIGNE)
VALUES (NULL, 100, ' PUT EDIT(''-----------------'')(SKIP ,A);');


Regards,

Kaeluan

Thanks for taking the time to report this issue and sorry for the problem you have experienced.
Fix of the error will be included in the next build of dbForge Data Compare for Oracle. We will notify you as soon as the next build is available for download.

This bug is already fixed. Please download the recent version of dbForge Data Compare for Oracle. The latest version is 1.00.15.
http://www.devart.com/dbforge/oracle/da ... nload.html