OraFAQ Forum: SQL & PL/SQL » Reading mail from outlook

Home » SQL & PL/SQL » SQL & PL/SQL » Reading mail from outlook (oracle 9i, outlook2003)

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

Reading mail from outlook [message #358354]

Mon, 10 November 2008 19:32

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

Report message to a moderator

Re: Reading mail from outlook [message #358387 is a reply to message #358354]

Tue, 11 November 2008 01:29

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Reading mail from outlook [message #358526 is a reply to message #358387]

Tue, 11 November 2008 15:44

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Truncate 1000 tables
Next Topic:	Exception PLSQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 19:06:56 CST 2025