asMail is an Oracle PL/SQL-based utility for retrieving emails from any pop3 or imap compliant mailbox and loading their contents and attachments into tables in your database.

Features

• Compatible with POP3 and IMAP mailboxes
• Email content and attachments loaded into two related tables (EMAIL_DETAIL and EMAIL_ATTACHMENT)
• Archive emails to a mail folder of your choice
• Includes a tracing routine for troubleshooting and diagnostics

Requirements

The target DB must have the JVM (JServer option installed) and have the appropriate JavaMail API loaded (mail.jar and activation.jar). Tested on 9i R2 but should run on all DB versions with a JVM installed.

Parameter	Description
mailbox_type	The email mailbox protocol, ie imap or pop3.
mailserver_address	The mailserver hostname or IP address.
account_name	The email account name.
account_pass	The email account password.
max_retrieve	Specifies the number of emails to download, default is all (null).
mailserver_port	The mailserver port number. If not specified, defaults to 25 for pop3 or 143 for imap.
archive_folder	Specifies the mail folder that retrieved emails shoule be moved to. Applies to imap accounts only.