error:
12725 ORA-12725: unmatched parentheses in regular expression ORA-06512: at "abcdePKG", line 5727 ORA-06512: at "abcde_PKG", line 5727
code thats givingewrror.
select LOWER (
REGEXP_REPLACE (
:program_title,
REGEXP_SUBSTR (:string, '\S+$'),
DECODE (
REGEXP_SUBSTR (:string, '\S+$'),
'I', '1',
'II', '2',
'III', '3',
'IV', '4',
'V', '5',
'VI', '6',
'VII', '7',
'VIII', '8',
'IX', '9',
REGEXP_SUBSTR (:string, '\S+$')),
1,
1)) from dual;
sample data can be ...Public Enemy (feat. Kev Wells)
basically the code failing when a string has parethisis and inside more than one word with space.
Thanks very much.
![