Hello,
We have defined an Event that sends an email in Spanish with accents.
The mail is sent, but all the accents disappear in the message.
How can we show the accents in the message?.
Below the Event Action:
DECLARE
v_From VARCHAR2(80) := 'aaa@XXXX.com';
v_Recipient VARCHAR2(80) := 'bbb@XXXX.com';
v_Subject VARCHAR2(80) := 'Nueva evaluación de proveedor';
v_Mail_Host VARCHAR2(30) := 'smtp.XXXX.com';
v_Mail_Conn utl_smtp.Connection;
crlf VARCHAR2(2) := chr(13)||chr(10);
msg VARCHAR2(1000):=NULL;
BEGIN
msg:='Se solicita realizar la evaluación de la orden de compra &NEW:PO_REF_NUMBER, con código de proyecto &NEW:PROJECT_ID. ' ;
v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25);
utl_smtp.Helo(v_Mail_Conn, v_Mail_Host);
utl_smtp.Mail(v_Mail_Conn, v_From);
utl_smtp.Rcpt(v_Mail_Conn, v_Recipient);
utl_smtp.Data(v_Mail_Conn,
'From: ' || v_From || crlf ||
'Subject: '|| v_Subject || crlf ||
'To: ' || v_Recipient || crlf ||
crlf ||
msg || crlf -- Message body
);
utl_smtp.Quit(v_mail_conn);
EXCEPTION
WHEN utl_smtp.Transient_Error OR utl_smtp.Permanent_Error then
raise_application_error(-20000, 'Unable to send mail', TRUE);
END;
This is how we receive the email:
[EXTERNAL] Nueva evaluacion de proveedor
Se solicita realizar la evaluacion de la orden de compra 28, con codigo de proyecto 18BE011800.
Best regards,
Amaia
