• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

how do i send emails using PL/SQL

How can i send emails using PL/SQL ? are there any prerequisite steps required to send out emails using database ? Thanks.
  • 3
3 Solutions
DavidSenior Oracle Database AdministratorCommented:
This is a previously asked question, try querying E-E and you'll have an abundant answer:
as for pre-requisites, it will depend on your version and exactly what method you are using.

for instance, if you are using utl_mail you need to set a few init parameters (see articles above)

if you are on 11g you need to open access control lists for your smtp server (at minimum)



ACL's require XDB to be installed (which it should be by default in 11g anyway)

if you are on 8i or 9i you will need java installed, which is not a default
why the B?  penalty grades are not appropriate if you have not requested additional information
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now