Reg: ORA-12728 invalid range in regular expression issue
684544Feb 11 2009 — edited Feb 11 2009Hi,
I’m working as PL/SQL developer. I have written a query to compare two different table column values without replace any special characters on it, but some case one particular table column value should be replaced with special characters, so in that case while doing the checking I need not replace the special characters but I need to compare removed with special characters.
I used oracle regular expression (regexp_replace) to replace special characters (/.#'& "\-+) (not physically) while comparing two column values, but im getting en error message like “ORA-12728: invalid range in regular expression”.
Even I tired as mentioned in the below, no hope, if I remove ‘\’ character in the list it working fine. Can any one help me on this.
Select regexp_replace(‘kathu&+’,’[.#'& "\-+]’)from dual
Thanks
kathu