Home » SQL & PL/SQL » SQL & PL/SQL » sending email with authentication (Oracle 10ex, on open suse 11.1)
sending email with authentication [message #423673] Sat, 26 September 2009 05:36 Go to next message
mearaj.accounts
Messages: 3
Registered: May 2007
Junior Member
Hi

i am using the following procedure to send email (from a trigger)
HTMLDB_MAIL.SEND(
p_to => :NEW.TO_EMAIL,
p_from => :NEW.FROM_EMAIL,
p_subj => :NEW.SUBJECT,
p_body => :NEW.BODY);

i can send emails only within my domain, but i need to authenticate in order to send email out side the domain

is there is a way to use a user-name and password and authenticate to the email server??

i have checked both 'utl_mail' and 'utl_smtp' but both does not seems to have a parameter for credentials

Re: sending email with authentication [message #423682 is a reply to message #423673] Sat, 26 September 2009 08:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>is there is a way to use a user-name and password and authenticate to the email server??
No, such rules are implemented at your local PostOffice (MTA) system to prevent spam relay.

>i have checked both 'utl_mail' and 'utl_smtp' but both does not seems to have a parameter for credentials
Configuration of local MAT must be change to allow it to forward messages originating on DB server system.

Re: sending email with authentication [message #423692 is a reply to message #423673] Sat, 26 September 2009 09:59 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
With utl_mai lyou can't but with utl_smtp it is possible. See
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12526941604660#51890874357845
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:255615160805#70457043064809

Regards
Michel
Previous Topic: Impact on table when it is renamed
Next Topic: greater of value in a given list
Goto Forum:
  


Current Time: Tue Feb 11 02:35:01 CST 2025