brianvanschellebeck
asked on
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.
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.
ASKER
Thank you for the answer but What I need is how to read emails from oracle without the use of an email server.
>> 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.
To read EMail sent by using standard protocols you require an EMail browser like outlook. Oracle does not store the EMails that are sent.
ASKER
The only way to be able to read email from oracle would be by creating an email server then?
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
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
http://www.dbasupport.com/oracle/ora9i/oracleemail.shtml
ASKER
From the links ive read dbms_smtp are for sending emails.
Any other way of reading emails from oracle without email server?
Any other way of reading emails from oracle without email server?
I don't think it's possible to do that.
ASKER
I still need a solution for this problem.
Can MohanKNair give me references for using dbms_smtp.
Regards,
Brian.
Can MohanKNair give me references for using dbms_smtp.
Regards,
Brian.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Update please...
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