I know that is possible to send mails using the oracle-db by UTL_SMTP, and there are several examples of such usage everywhere.
My question is: Can I call the GNU/Unix/Linux Sendmail to perform a similar action?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI know that is possible to send mails using the oracle-db by UTL_SMTP, and there are several examples of such usage everywhere.
My question is: Can I call the GNU/Unix/Linux Sendmail to perform a similar action?
Why do you want to use sendmail? Is it just because it is simpler than UTL_SMTP? You should really look into UTL_MAIL.
See this: http://www.orafaq.com/wiki/Send_mail_from_PL/SQL
To send mail from an Oracle db, you might:
dbms_scheduler
package which has support for invoking an external program. – Colin 't Hart May 29 '14 at 19:54