Thanks for the question, venkatesh.
Asked: February 23, 2017 - 10:45 am UTC
Last updated: February 23, 2017 - 12:04 pm UTC
Version: Oracle Database 11gR1 and R2 / 12c
Viewed 1000+ times
You Asked
Hi Tom,
below function is used to send mail. but recently I upgraded DB to 12c from 11gR1/R2, I am not getting body part of mail.
I am getting notification mail with subject line but missing the body part.
please help.
function :
----------
Function mail_msg (recip char, subject char, msg char) return BINARY_INTEGER
IS EXTERNAL
library system.mailer
name "mail_msg"
Parameters (
recip,
subject,
subject indicator,
msg,
return);
and Connor said...
Thats outside the scope of the database - because you're calling an external program. Have you replicated all of the external program calling requirements from the 11g oracle_home to the 12c oracle_home ?
Have you considered using UTL_MAIL or UTL_SMTP instead, rather than have the dependency on external routines ?
Is this answer out of date? If it is, please let us know via a Comment