Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conversion to html characters

InoLSep 27 2013 — edited Sep 28 2013

Is there a standard function (in 11.2) to convert special characters to the HTML equivalent? I've been searching for this function, but haven't found one yet.

I do not mean a URL escape:

SQL> select utl_url.escape('é') coded from dual;

CODED

----------

%BF

but a function that would return

SQL> select some_function('é') coded from dual;

CODED

----------

é



I need to send html emails using a mail package that uses utl_smtp.data. This strips the special characters.

I know this can be solved by using utl_smtp.write_raw_data. Since it is a standard mail package, my options are limited in modifying that package. Instead of modifying the package, I am looking into converting the email html text to encoded html first.


Thanks


Ino


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2013
Added on Sep 27 2013
3 comments
4,029 views