| Oracle Mail: Problem in UTF8 Conversion [message #193750] |
Tue, 19 September 2006 05:01  |
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 ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
