Home » SQL & PL/SQL » SQL & PL/SQL » How to Send E-Mail in Oracle(PL-SQL) very urgent please
How to Send E-Mail in Oracle(PL-SQL) very urgent please [message #620801] Wed, 06 August 2014 04:31 Go to next message
swamy6040
Messages: 5
Registered: October 2013
Location: Hatyana
Junior Member
i want send E-mail through G-Mail with attached File so Please help me
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
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 Go to previous messageGo to next message
swamy6040
Messages: 5
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?
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 Go to previous messageGo to next message
swamy6040
Messages: 5
Registered: October 2013
Location: Hatyana
Junior Member
My

Oracle DB version : 10.2.0.3.0
Windows OS is : Windows 7
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 Go to previous messageGo to next message
Maaher
Messages: 7055
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
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.

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 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
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.
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 Go to previous messageGo to next message
swamy6040
Messages: 5
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?
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
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?
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 Go to previous messageGo to next message
swamy6040
Messages: 5
Registered: October 2013
Location: Hatyana
Junior Member
i am useing my gmail credentials
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 Go to previous messageGo to next message
John Watson
Messages: 4870
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 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
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.
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 Go to previous message
Lalit Kumar B
Messages: 2544
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.
Previous Topic: SQL Update - Avoid Unique Constraint Error
Next Topic: Clustered index on primary key columns
Goto Forum:
  


Current Time: Sun Dec 28 01:23:36 CST 2014

Total time taken to generate the page: 0.08251 seconds