Problem with Oracle Data Compare Tool

Kaeluan · Post by **Kaeluan** » Sat 04 Sep 2010 20:13

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

.jp · Post by **.jp** » Mon 06 Sep 2010 07:11

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.

.jp · Post by **.jp** » Fri 10 Sep 2010 12:17

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