PL/SQL (MOSC)

MOSC Banner

different results in sending mail from oracle db, same version, same installation, same os

in PL/SQL (MOSC) 3 commentsAnswered

Hi all,

I am using this code for sending mail with hyper link

declare

v_link varchar2(100):='<a href=https://www.gov.il/he/departments/water_authority>water athoraty site</a>';

errorstatus number;

ErrorMessage varchar2(10000);

str varchar2(100):='d:\Orafiles\רררררר\bbb\11.txt';

begin

  --send_mail( 'errr','elenah@water.gov.il','c:\temp\מעיינות נובמבר 2018.xlsx'); 

errorstatus := sendmailjpkg.sendmail 

          ('watercas.water.gov.il',

          'oracle@water.gov.il',               

          'eitanl@water.gov.il',   

          '',                        

          '',                           

          'errrr',                   

            'שלום '||12345||','||chr(11)||'רישיון נשלך אלך'||chr(11) ||'ניסוי HYPERLINK'||chr(11)||v_link,                     

          ErrorMessage,

          null);--S:\מחלקת רישוי\שנת 2020\רישיונות ביתר הארץ\49

           

  dbms_output.put_line(errorstatus);         

end;

this procedure is using Java classes

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center