Hi All,
We have a requirement to skip the HTML tags when I am displaying in the BIP report output. I developed below query and it is working fine when I tested for few records.
When I am running the entire report and I am getting below error,
"Java.sql.SQLException: ORA-12733: regular expression too long."
Kindly review the below SQL query and suggest to skip this error.
select regexp_replace(:T,b.s,' ') from dual a,
(select LISTAGG (text,'|')
WITHIN GROUP (ORDER BY null) s
from (select distinct substr(:T,instr(:T,'<',1,level),instr(:T,'>',1,level)-instr(:T,'<',1,level)+1) text
from dual
connect by level<=REGEXP_COUNT(:T,'<'))) b
Thanks,
Visu