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
hprasetya
Messages: 1
Registered: September 2006
Location: France
Junior Member
Hi,

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.ehlo(conn,<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
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Tom Kyte has a package that works fine:

http://asktom.oracle.com/pls/ask/f?p=4950:8:5465913024471305788::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:255615160805

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


Current Time: Fri Dec 02 23:03:30 CST 2016

Total time taken to generate the page: 0.27463 seconds