Problem with Oracle Data Compare Tool

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Kaeluan
Posts: 1
Joined: Sat 04 Sep 2010 20:00
Location: Canada

Problem with Oracle Data Compare Tool

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
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

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
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

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

Post Reply