Home » SQL & PL/SQL » SQL & PL/SQL » Reading mail from outlook (oracle 9i, outlook2003)
Reading mail from outlook [message #358354] Mon, 10 November 2008 19:32 Go to next message
jithu
Messages: 2
Registered: November 2008
Junior Member
Hi Team,

i need to develop a application that will read mails. i have outlined requirement below
1) i have redirected emails with specific subject(say ACCNO--USERID--CODE) line to one folder present in my outlook.
2) Now i need to extract the USERID from the subject line through plsql.

i'm having little knowledge of utl_smtp and aware we can send mail through that but never user to read mails.

Thank You
--Jithu
Re: Reading mail from outlook [message #358387 is a reply to message #358354] Tue, 11 November 2008 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't read mail with UTL_SMTP.
From doc:
Quote:
The UTL_SMTP package is designed for sending electronic mails (emails) over Simple Mail Transfer Protocol (SMTP) as specified by RFC821.


Search for a package that implements POP3 or IMAP protocol, maybe you can find one with HTTP but it is harder.

Regards
Michel
Re: Reading mail from outlook [message #358526 is a reply to message #358387] Tue, 11 November 2008 15:44 Go to previous messageGo to next message
jithu
Messages: 2
Registered: November 2008
Junior Member
Thanks Michel...

I would prefer java application, which is every easy to impliment. Just a clarification before that, utl_mail also desinged for mail sending only?

[Updated on: Tue, 11 November 2008 15:45]

Report message to a moderator

Re: Reading mail from outlook [message #358639 is a reply to message #358526] Wed, 12 November 2008 00:57 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just a look at doc:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_mail.htm#i1001258

Or event quicker:
SQL> desc utl_mail
PROCEDURE SEND
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SENDER                         VARCHAR2                IN
 RECIPIENTS                     VARCHAR2                IN
 CC                             VARCHAR2                IN     DEFAULT
 BCC                            VARCHAR2                IN     DEFAULT
 SUBJECT                        VARCHAR2                IN     DEFAULT
 MESSAGE                        VARCHAR2                IN     DEFAULT
 MIME_TYPE                      VARCHAR2                IN     DEFAULT
 PRIORITY                       BINARY_INTEGER          IN     DEFAULT
PROCEDURE SEND_ATTACH_RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SENDER                         VARCHAR2                IN
 RECIPIENTS                     VARCHAR2                IN
 CC                             VARCHAR2                IN     DEFAULT
 BCC                            VARCHAR2                IN     DEFAULT
 SUBJECT                        VARCHAR2                IN     DEFAULT
 MESSAGE                        VARCHAR2                IN     DEFAULT
 MIME_TYPE                      VARCHAR2                IN     DEFAULT
 PRIORITY                       BINARY_INTEGER          IN     DEFAULT
 ATTACHMENT                     RAW                     IN
 ATT_INLINE                     BOOLEAN                 IN     DEFAULT
 ATT_MIME_TYPE                  VARCHAR2                IN     DEFAULT
 ATT_FILENAME                   VARCHAR2                IN     DEFAULT
PROCEDURE SEND_ATTACH_VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SENDER                         VARCHAR2                IN
 RECIPIENTS                     VARCHAR2                IN
 CC                             VARCHAR2                IN     DEFAULT
 BCC                            VARCHAR2                IN     DEFAULT
 SUBJECT                        VARCHAR2                IN     DEFAULT
 MESSAGE                        VARCHAR2                IN     DEFAULT
 MIME_TYPE                      VARCHAR2                IN     DEFAULT
 PRIORITY                       BINARY_INTEGER          IN     DEFAULT
 ATTACHMENT                     VARCHAR2                IN
 ATT_INLINE                     BOOLEAN                 IN     DEFAULT
 ATT_MIME_TYPE                  VARCHAR2                IN     DEFAULT
 ATT_FILENAME                   VARCHAR2                IN     DEFAULT

Only SEND procedures.

Regards
Michel
Previous Topic: Truncate 1000 tables
Next Topic: Exception PLSQL
Goto Forum:
  


Current Time: Fri Dec 02 20:48:35 CST 2016

Total time taken to generate the page: 0.16128 seconds