SWilk SWilk - 10 months ago 148
HTML Question

How to escape <, >, and & characters to html entities in Oracle PL/SQL

I need to send HTML emails directly from oracle PL/SQL package. This works almost fine.

I have problem with the fact that some of the data fetched from a table contain things like <S>, <L>, and similar fragments, which sometimes ar treated as HTML tags, and even if not, they are always ignored and never displayed.

So, I need to escape this column before inserting into email body.

Is there a function to escape html special chars into entities automaticly?
Or do I need to replace('<','&lt;',string) manually all the special characters?

I found a function to escape URLs but not one for HTML :(

Best regards,


You can use the htf.escape_sc function:

SQL> select htf.escape_sc('Please escape <this> tag') from dual;

Please escape &lt;this&gt; tag