Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Mail: Problem in UTF8 Conversion
Oracle Mail: Problem in UTF8 Conversion [message #193750] Tue, 19 September 2006 05:01 Go to next message
Messages: 1
Registered: September 2006
Location: France
Junior Member

I'm trying to send email from Oracle PL/SQL, using UTL_SMTP package, and found the code for login in the forum, below:

conn := utl_smtp.open_connection(<smtp_server>);
utl_smtp.command(conn, 'AUTH LOGIN');
utl_smtp.command(conn, utl_encode.base64_encode(utl_raw.cast_to_raw(<username>)));
utl_smtp.command(conn, utl_encode.base64_encode(utl_raw.cast_to_raw(<password>)));

But the code above given me this error:
501 5.5.0 Invalid input (Invalid Username; UTF-8 required).

It's true that my DB NLS_CHARACTERSET is not UTF8 (it's WE8MSWIN1252), so how can I convert my user name & password to UTF8 ?

Or somebody has better idea on sending email via PL/SQL that required authentication to mail server ?
Re: Oracle Mail: Problem in UTF8 Conversion [message #194847 is a reply to message #193750] Mon, 25 September 2006 13:37 Go to previous message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Tom Kyte has a package that works fine:


Previous Topic: Help needed
Next Topic: Oracle CICS Question
Goto Forum:

Current Time: Tue Jul 25 10:15:50 CDT 2017

Total time taken to generate the page: 0.17161 seconds