?
Solved

how can I process an email inbox in pl/sql

Posted on 2011-09-07
2
Medium Priority
?
1,789 Views
Last Modified: 2012-05-12
automated email notifications will go to a particular email.  I'd like to read the inbox, process the email, and then delete it.  these are small emails--less than 2k.  What is the easiest way to do this from pl/sql?
0
Comment
Question by:stirus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 36496572
there is no built in functionality for reading email in Oracle.  Only sending email.

You can however implement your own pop3 client using utl_tcp  package.

this question from the AskTom (Tom Kyte) site has a start on such a procedure


http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:952039400346097108
0
 
LVL 7

Assisted Solution

by:Jacobfw
Jacobfw earned 1000 total points
ID: 36559987
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question