HI,
I'm trying to send mail using utl_mail.send with hebrew charecters,
But the mail I'm getting is with ????
I understand that outlook works only with ISO-8859-8
so I tried to set it on mine_type but it didn't help.
DECLARE
var VARCHAR2(1024);
BEGIN
var := q'[שלום]';
DBMS_OUTPUT.PUT_LINE(var);
utl_mail.send(sender => 'oracle@org.co.il',
recipients => '&1',
message => var,
mime_type => 'text/html charset=iso-8859-8'
);
END;
/
exit
Do you have any idea?
Lior