Home » RDBMS Server » Server Administration » send & receive email through oracle
send & receive email through oracle [message #376419] Wed, 17 December 2008 05:01 Go to next message
panduoracledba
Messages: 14
Registered: September 2008
Junior Member
Hi every one.
is there any way , to get the content of the mail through oracle.
thank you

[Updated on: Thu, 18 December 2008 00:36] by Moderator

Report message to a moderator

Re: send & receive email through oracle [message #376424 is a reply to message #376419] Wed, 17 December 2008 05:13 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Not. Theoretically you could use utl_tcp to write a POP3 client, but that would be the worst possible idea imaginable.

Get a command line mail client or another scripting language like PERL that can both read mail and connect to Oracle and to it that way.
Re: send & receive email through oracle [message #376501 is a reply to message #376419] Wed, 17 December 2008 11:03 Go to previous messageGo to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Hi,

You may use blat utility for windows and mailx for unix if you have SMTP server.

But that requires a good(expensive) setup. And is applicable for production level.

Regards,
Sam G
Re: send & receive email through oracle [message #376510 is a reply to message #376501] Wed, 17 December 2008 11:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
How does this answer the question "to get the content of the mail through oracle"?

Regards
Michel
Re: send & receive email through oracle [message #376597 is a reply to message #376510] Thu, 18 December 2008 00:09 Go to previous messageGo to next message
panduoracledba
Messages: 14
Registered: September 2008
Junior Member
thanks Michel,for your kind response,i am a fresher..,here i mean we can send the mail using oracle built in packages.but i do not know, whether there is a way or not, to get the mail information & the mail content.
thanks & regards
Sriram.

[Updated on: Thu, 18 December 2008 00:36] by Moderator

Report message to a moderator

Re: send & receive email through oracle [message #376606 is a reply to message #376501] Thu, 18 December 2008 00:31 Go to previous messageGo to next message
panduoracledba
Messages: 14
Registered: September 2008
Junior Member
thanks sam.basically i have an idea,if i have an information about incoming mails,then i want those mails to be stored in some table,or at least, the email address from which the mail is arrived.
we can communicate with the mail server, i mean oracle delivers the mail to the mail server and the m.server sends the mail to address specified right? is this procedure vice versa ? if i am wrong please let me know.
thanks & regards
sriram

[Updated on: Thu, 18 December 2008 00:36] by Moderator

Report message to a moderator

Re: send & receive email through oracle [message #376610 is a reply to message #376606] Thu, 18 December 2008 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Thomas already answered to your question, doesn't it?

And use code tags only when it is useful. And then always use the "Preview Message" button to verify. and make sure that lines of code do not exceed 80 characters when you format.

Regards
Michel
Re: send & receive email through oracle [message #376613 is a reply to message #376610] Thu, 18 December 2008 00:50 Go to previous message
panduoracledba
Messages: 14
Registered: September 2008
Junior Member
thanks Michel.
i will try that & get back to you
Previous Topic: SYS user and RECYCLEBIN/DROP
Next Topic: ORA-00059: maximum number of DB_FILES exceeded
Goto Forum:
  


Current Time: Thu Dec 05 14:08:16 CST 2024