OraFAQ Forum: SQL & PL/SQL » Procedure to read mails from mailbox and insert into table

Home » SQL & PL/SQL » SQL & PL/SQL » Procedure to read mails from mailbox and insert into table (oracle 11.2.0.1.0 windows XP)

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

Procedure to read mails from mailbox and insert into table [message #616926]

Mon, 23 June 2014 03:57

kavirajd
Messages: 1
Registered: June 2014
Location: bangalore

Junior Member

I need sample procedure to read mails from my mailbox and insert into some tables

Report message to a moderator

Re: Procedure to read mails from mailbox and insert into table [message #616928 is a reply to message #616926]

Mon, 23 June 2014 04:03

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

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

You need to provide more information. For example, is this this "mailbox" a set of rows in an Oracle table? Or is it a box by your front gate into which your local postman puts letters?

Report message to a moderator

Re: Procedure to read mails from mailbox and insert into table [message #616929 is a reply to message #616926]

Mon, 23 June 2014 04:07

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

Senior Member

Your mailbox? You cannot read emails from a client, it is possible only with server, like exchange server. A similar thread from OTN forums where Billy posted a basic code of a PL/SQL pipelined table function that wraps a POP3 mail account into a SQL table https://community.oracle.com/message/2020101#2020101.

Report message to a moderator

Previous Topic:	Sys_refcursor
Next Topic:	assertions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 13:52:53 CDT 2024