SQL & PL/SQL

Hello,

I need to convert unicode characters in my data to html entities in order to present them as html content. Currently, I do these replacements manually for the characters that I know I will probably have, e.g.:

l_text := replace(replace(replace(replace(replace(replace(l_text, chr(U+197), 'Å'),  chr(U+196), 'Ä'),   chr(U+195), 'Ã'), chr(U+194), 'Â'),  chr(U+193), 'Á'), chr(U+192), 'À');

Is there a way to do the replacements all together using an oracle function? (...hoping for a better performance as well...)

I saw that there was already an old discussion about this since 2009 but without an answer How to convert to HTML entities?

and I hope that now (6 years later) maybe there is a solution :-)

Does anyone have an idea?

Thanks a lot in advance!

Regards,

A.L.