tOracleInput using regexp, Invalid escape sequence

[Anonymous]

Hello all

How to use in SQL query in tOracleInput statements like this?

"

select

...

REGEXP_COUNT(p.num,'[А-Яа-я]|[;]|(\,\ \ )|(\ \,)|(\w\ \w)|(\w\,\w)') field1,
REGEXP_COUNT(p.num,'([a-zA-Z0-9.\_\-])+[\@]+([a-zA-Z0-9.\_\-]){0,61}+[\.]+[a-zA-Z]{2,6}') field2,

....

"

When I build job I got error Invalid escape sequence (valid ones are  \b  \t  \n  \f  \r  \"  \'  \\ )

replace all '\' on '\' doesn't help

[cterenzi · Accepted solution]

Your sql string is interpreted by Java first, then passed to Oracle. In your tOracleInput sql, replace all '\' with '\\'.

[Anonymous]

I've done this replace, don't help

[cterenzi]

If you get the same error message, you missed one.

[Anonymous]

Thank yoy, I really missed one