Portal

Hello,

My query with regular expressions is modified in xDI Process.

Here is my original Oracle query :

table(cast(multiset(select level from dual connect by  level <= length (regexp_replace(REPLACE(HIRE_NOTES_2.Hire_Notes,CHR(13)||CHR(10),'|'), '[^|]+'))  + 1) as sys.OdciNumberList))

Here is the query in xDI process :

(table(cast(multiset(select level from dual connect by level <= length (regexp_replace(REPLACE(HIRE_NOTES_2.Hire_Notes,CHR(13)||CHR(10),'|'), '[^||[^|+'))  + 1) as sys.OdciNumberList))

To fix this issue we should use double bracket in regular expression: