Re: REGEXP_SUBSTR() is always NULL
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 25 Jun 2009 07:10:51 -0700 (PDT)
Message-ID: <6e6890f3-61b1-47fa-a568-f73235b22de2_at_l28g2000vba.googlegroups.com>
On Jun 25, 7:52 am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com> wrote:
> ddf escribió:
>
> > On Jun 25, 6:29 am, "Álvaro G. Vicario"
> > <alvaro.NOSPAMTH..._at_demogracia.com> wrote:
> >> In an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 server,
> >> REGEXP_SUBSTR() always returns NULL. E.g.:
>
> >> SELECT REGEXP_SUBSTR('1234,5678', '\d+', 1, 1)
> >> FROM DUAL
>
> >> In my local 10g XE, however, it returns 1234 as expected.
>
> >> Is it me or is it the server?
> > It may be the server if you are, indeed, comparing XE (10.2.0.1) to a
> > 10.1.0.2 release. You're certain you've posted the version for the
> > Enterprise Edition correctly?
>
> Absolutely: SELECT BANNER FROM v$version + clipboard.
>
> If it was a legacy edition that did not support REGEXP_SUBSTR() I'd
> expect an error message.
>
> Is it possible to cancel, disabled or override REGEXP_SUBSTR?
>
> --
> --http://alvaro.es- Álvaro G. Vicario - Burgos, Spain
> -- Mi sitio sobre programación web:http://borrame.com
> -- Mi web de humor satinado:http://www.demogracia.com
> --
Date: Thu, 25 Jun 2009 07:10:51 -0700 (PDT)
Message-ID: <6e6890f3-61b1-47fa-a568-f73235b22de2_at_l28g2000vba.googlegroups.com>
On Jun 25, 7:52 am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com> wrote:
> ddf escribió:
>
> > On Jun 25, 6:29 am, "Álvaro G. Vicario"
> > <alvaro.NOSPAMTH..._at_demogracia.com> wrote:
> >> In an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 server,
> >> REGEXP_SUBSTR() always returns NULL. E.g.:
>
> >> SELECT REGEXP_SUBSTR('1234,5678', '\d+', 1, 1)
> >> FROM DUAL
>
> >> In my local 10g XE, however, it returns 1234 as expected.
>
> >> Is it me or is it the server?
> > It may be the server if you are, indeed, comparing XE (10.2.0.1) to a
> > 10.1.0.2 release. You're certain you've posted the version for the
> > Enterprise Edition correctly?
>
> Absolutely: SELECT BANNER FROM v$version + clipboard.
>
> If it was a legacy edition that did not support REGEXP_SUBSTR() I'd
> expect an error message.
>
> Is it possible to cancel, disabled or override REGEXP_SUBSTR?
>
> --
> --http://alvaro.es- Álvaro G. Vicario - Burgos, Spain
> -- Mi sitio sobre programación web:http://borrame.com
> -- Mi web de humor satinado:http://www.demogracia.com
> --
I can duplicate the expected result on 10.2.0.3 running on AIX 5.3L. Does anyone have a 10.1 version that can be used to duplicate the OP issue?
I have posted to another forum to see if anyone with a 10.1 system can duplicate the issue. I suspect a patch level specific issue, but there could be another cause.
HTH -- Mark D Powell -- Received on Thu Jun 25 2009 - 09:10:51 CDT