OraFAQ Forum: SQL & PL/SQL » How to Send E-Mail in Oracle(PL-SQL) very urgent please

Home » SQL & PL/SQL » SQL & PL/SQL » How to Send E-Mail in Oracle(PL-SQL) very urgent please

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620801]

Wed, 06 August 2014 04:31

swamy6040
Messages: 9
Registered: October 2013
Location: Hatyana

Junior Member

i want send E-mail through G-Mail with attached File so Please help me

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620804 is a reply to message #620801]

Wed, 06 August 2014 04:32

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

If it's that URGENT, please google yourself.

Read http://www.orafaq.com/forum/t/88153/

[Updated on: Wed, 06 August 2014 04:36]

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620808 is a reply to message #620804]

Wed, 06 August 2014 04:41

swamy6040
Messages: 9
Registered: October 2013
Location: Hatyana

Junior Member

Already i am trying with google search. i got some mail sending links but those solutions are give some smtp error any other way is it posiable?

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620809 is a reply to message #620808]

Wed, 06 August 2014 04:45

swamy6040
Messages: 9
Registered: October 2013
Location: Hatyana

Junior Member

My

Oracle DB version : 10.2.0.3.0
Windows OS is : Windows 7

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620810 is a reply to message #620808]

Wed, 06 August 2014 04:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

"some smtp error"? Ok, read the link posted by Lalit. If you want a detailed anwser you will need to give details yourself. What error message? What have you tried? and please format your code.

MHE

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620812 is a reply to message #620808]

Wed, 06 August 2014 04:56

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

i got some mail sending links but those solutions are give some smtp error any other way is it posiable?

Fix the errors then it will be OK, you won't need another way.

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620832 is a reply to message #620801]

Wed, 06 August 2014 09:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

swamy6040 wrote on Wed, 06 August 2014 02:31

i want send E-mail through G-Mail with attached File so Please help me

gmail won't relay your SPAM messages.
You require a locally configured Mail Transport Agent.

This problem & solution have NOTHING to do with Oracle RDBMS.

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #621541 is a reply to message #620832]

Thu, 14 August 2014 02:02

swamy6040
Messages: 9
Registered: October 2013
Location: Hatyana

Junior Member

dear Member's

i am trying below process for sending e-mail

SQL>sqlplus '/ as sysdba'
SQL>@C:/oracle/product/10.2.0/db_1/RDBMS/admin/utlmail.sql
SQL>@C:/oracle/product/10.2.0/db_1/rdbms/admin/prvtmail.plb
SQL>alter system set smtp_out_server='smtp.gmail.com:465 scope=both;
SQL>exec utl_mail.send(sender=>'swamy.chintala@gmail.com',recipients=>'swamy.chintala@gmail.com',subject=>'Testing UTL_MAIL Option',message=>'email testing mesage');

but it show below error

ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 20
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "SYS.UTL_MAIL", line 395
ORA-06512: at "SYS.UTL_MAIL", line 608
ORA-06512: at line 2

how to solve this?

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #621542 is a reply to message #621541]

Thu, 14 August 2014 02:06

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

swamy6040 wrote on Thu, 14 August 2014 12:32

ORA-29278: SMTP transient error: 421 Service not available

What do you think 421 Service not available error is? Do you have the credentials?

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #621543 is a reply to message #621542]

Thu, 14 August 2014 02:09

swamy6040
Messages: 9
Registered: October 2013
Location: Hatyana

Junior Member

i am useing my gmail credentials

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #621550 is a reply to message #621543]

Thu, 14 August 2014 04:10

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

You are not telling the truth! This command does not succeed:

orclz> alter system set smtp_out_server='smtp.gmail.com:465 scope=both;
alter system set smtp_out_server='smtp.gmail.com:465 scope=both
                                 *
ERROR at line 1:
ORA-01756: quoted string not properly terminated


orclz>

furthermore, you have not set any credentials. You need to use utl_smtp to authenticate properly.

[Updated on: Thu, 14 August 2014 04:11]

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #621574 is a reply to message #621550]

Thu, 14 August 2014 08:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

gmail won't relay your SPAM messages.
You require a locally configured Mail Transport Agent.

This problem & solution have NOTHING to do with Oracle RDBMS.

Report message to a moderator

Re: How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #621577 is a reply to message #621574]

Thu, 14 August 2014 09:46

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I echo BS, not necessarily that Ora errors mean the problem resides at Oracle side. In this case, it's all about mail server configuration. Oracle is only a victim while alerting uaers about the issue. And the error details provide enough information for troubleshooting and required fix.

Report message to a moderator

Previous Topic:	SQL Update - Avoid Unique Constraint Error
Next Topic:	Clustered index on primary key columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:19:47 CDT 2024