How to remove img tag in BI Publisher Bursting Email Body ?
We are trying to retrieve the message content uploaded on the Help Desk Service Request
The following code has been used to remove html tag which were being triggered:
SELECT DISTINCT
'1' AS KEY
,ssr.TITLE
,hp.PARTY_NAME
,TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(UTL_I18N.UNESCAPE_REFERENCE(DBMS_LOB.SUBSTR(lam.MESSAGE_CONTENT, 1500, 1)),'<[^>]>',' '),'&[^;];',' '),''',''''), CHR(10), ' '), CHR(13), ' ')) message_content
,ssr.LAST_UPDATE_DATE
,hp.email_address
FROM
SVC_SERVICE_REQUESTS ssr
,HZ_PARTIES hp
,LatestAssigneeMessage lam
,SVC_CHANNEL_VIA svc
Note: Message content was retrieved from table SVC_SR_MESSAGES
0