Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Read Email from Oracle

Posted on 2006-07-17
14
Medium Priority
?
1,500 Views
Last Modified: 2013-12-12
Hi,
I am actually using Outlook for email interaction but I would like to be able to access my emails from oracle directly while working, without creating an email server. Anyone can help? Thank you in advance. S.
0
Comment
Question by:brianvanschellebeck
[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
14 Comments
 
LVL 16

Expert Comment

by:MohanKNair
ID: 17120841
Oracle Application Server has Email Server component. The front-end is web based. The Email server is installed in Oracle database. Oracle Collaboration Suite also has Email Server as its component.

Oracle eMail Server Documentation
http://www.oracle.com/technology/documentation/emailserver.html


Oracle built-in package dbms_smtp can be used to programatically send/receive emails.

Sending E-mails from Oracle Database
http://www.dbasupport.com/oracle/ora9i/oracleemail.shtml

Sending email from the database with the Utl_Smtp package
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
0
 

Author Comment

by:brianvanschellebeck
ID: 17120888
Thank you for the answer but What I need is how to read emails from oracle without the use of an email server.
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 17120925
>> how to read emails from oracle
To read EMail sent by using standard protocols you require an EMail browser like outlook. Oracle does not store the EMails that are sent.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:brianvanschellebeck
ID: 17120942
The only way to be able to read email from oracle would be by creating an email server then?
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 17120957
You can also use Oracle Built-in Packages like dbms_smtp. But you should write code using PL/SQL.

http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
http://www.dbasupport.com/oracle/ora9i/oracleemail.shtml
0
 

Author Comment

by:brianvanschellebeck
ID: 17121035
From the links ive read dbms_smtp are for sending emails.

Any other way of reading emails from oracle without email server?
0
 
LVL 14

Expert Comment

by:sathyagiri
ID: 17140250
I don't think it's possible to do that.
0
 

Author Comment

by:brianvanschellebeck
ID: 17754731
I still need a solution for this problem.
Can MohanKNair give me references for using dbms_smtp.
Regards,
Brian.
0
 
LVL 16

Accepted Solution

by:
MohanKNair earned 2000 total points
ID: 17755067
See this link
How to get an Oracle Database to email you when there's a problem
http://www.dizwell.com/prod/node/135
0
 
LVL 20

Expert Comment

by:Venabili
ID: 17918769
Update please...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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

609 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