I am using utl_mail.send oracle 11g r2 for automate email in my Pl-SQL package. When i use the subject charater length more than 47 then the body of the email is getting corrupted(Attached the screenshot). Shorter subject length e-mail is coming perfect.
declare begin utl_mail.send(sender => 'Test@supersoft.com', subject => 'test10 Test10 more than 47 test 1234567890912312453254325345', message => 'Test', mime_type => 'text/plain; charset=us-ascii', recipients => 'interanet@supersoft.com'); end;
Could anyone please help me what might be the issue with this.