Not escaping slashes

[ghost]

ora2pg is generating this insert which fails:

INSERT INTO pp$provider_services (id,enabled,ext_service_id,priority,transform,provider_id,service_id,src,cdat,dealer_id) VALUES (30563049,'t',E'739556817',1,'t',25,499,E'var params;^M
var preparedParams;^M
preparedParams.put("phoneNumber", params.get("account"));^M
preparedParams.put("params[\''type\'']", "7");','2013-03-22 20:44:42',27249468);

Source text in Oracle for the SRC column is

var params;
var preparedParams;
preparedParams.put("phoneNumber", params.get("account"));
preparedParams.put("params[\'type\']", "7");

Proper escaping is:

=> select E'params[\\\'type\\\']';
 ?column?
------------------
 params[\'type\']
(1 row)

So basically for some reason ora2pg thinks the backslash should not be escaped at all, while the single quote should be doubled, which is wrong for E'' notation.

[ghost]

ora2pg v12.1
Oracle 10g

ora2pg config as in my other ticket, except the type is INSERT instead of COPY and I enabled file per table export.

[darold]

Hi Yuri,

That's right, last commit 872ad5b should fix this issue. Thanks for the report.

Best regards,

[ghost]

Thank you. Is it safe to use the build from that commit?

[darold]

Yes usually, the code on github is more stable than the tarball version.