Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: ORA-12728 invalid range in regular expression issue

684544Feb 11 2009 — edited Feb 11 2009
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2009
Added on Feb 11 2009
1 comment
3,565 views