Hellou everybody,
I have very strange problem and I don't understand WHY.
when i run this query:
SELECT regexp_instr(nvl(trim('LDAPexport_20150429'), '^.*$'),'^\^[0-9]{2,2}_[A-9]{1,1}[A-9]{1,4}/') FROM dual; --ERROR
I always getting this error: ORA-12728 - invalid range in regular expression
but when I run this:
SELECT regexp_instr(nvl(TRIM('LDAPexport_20150429'), '^.*$'), '^\^[0-9]{2,2}_[A-Z0-9]{1,1}[A-Z0-9]{1,4}/') FROM dual -IT WORKS
My client version is: 11.2.0.1.0
DB version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Please can somebody tell me what is the problem? Because I found this issue in production code and my collegues can run it.
Thank YOU