OraFAQ Forum: Server Administration » send & receive email through oracle

Home » RDBMS Server » Server Administration » send & receive email through oracle

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

send & receive email through oracle [message #376419]

Wed, 17 December 2008 05:01

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

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: send & receive email through oracle [message #376501 is a reply to message #376419]

Wed, 17 December 2008 11:03

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

Report message to a moderator

Re: send & receive email through oracle [message #376510 is a reply to message #376501]

Wed, 17 December 2008 11:32

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

Senior Member
Account Moderator

How does this answer the question "to get the content of the mail through oracle"?

Regards
Michel

Report message to a moderator

Re: send & receive email through oracle [message #376597 is a reply to message #376510]

Thu, 18 December 2008 00:09

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

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

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

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

Report message to a moderator

Re: send & receive email through oracle [message #376613 is a reply to message #376610]

Thu, 18 December 2008 00:50

panduoracledba
Messages: 14
Registered: September 2008

Junior Member

thanks Michel.
i will try that & get back to you

Report message to a moderator

Previous Topic:	SYS user and RECYCLEBIN/DROP
Next Topic:	ORA-00059: maximum number of DB_FILES exceeded

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 06:48:34 CDT 2024