• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1506
  • Last Modified:

Read Email from Oracle

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
brianvanschellebeck
Asked:
brianvanschellebeck
1 Solution
 
MohanKNairCommented:
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
 
brianvanschellebeckAuthor Commented:
Thank you for the answer but What I need is how to read emails from oracle without the use of an email server.
0
 
MohanKNairCommented:
>> 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
brianvanschellebeckAuthor Commented:
The only way to be able to read email from oracle would be by creating an email server then?
0
 
MohanKNairCommented:
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
 
brianvanschellebeckAuthor Commented:
From the links ive read dbms_smtp are for sending emails.

Any other way of reading emails from oracle without email server?
0
 
sathyagiriCommented:
I don't think it's possible to do that.
0
 
brianvanschellebeckAuthor Commented:
I still need a solution for this problem.
Can MohanKNair give me references for using dbms_smtp.
Regards,
Brian.
0
 
MohanKNairCommented:
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
 
VenabiliCommented:
Update please...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now