SQL Language (MOSC)

MOSC Banner

Error in the regular expression crashes application.

edited Dec 21, 2013 12:25AM in SQL Language (MOSC) 3 commentsAnswered
Sometimes my procedure using the expression '^-{0,1}*\d+*\d*$' crashes applications.
I have made a mistake in that expression,  I forgot to remove the "*" marked red, but this error should not cause the application to crash!

I think there is error in the regular expression engine, which show cases below:

select  case when (REGEXP_LIKE('-23,4','^-{0,1}*\d+,*\d*$')) then 1 else 0 end a from dual;  -- works
select  case when (REGEXP_LIKE('- 23,4','^-{0,1}*\d+,*\d*$')) then 1 else 0 end a from dual; -- crashes (add: " " between "-" and "23,4")

Tomasz Górniak

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center