Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Venkateswara.

Asked: August 05, 2001 - 12:24 pm UTC

Last updated: July 22, 2006 - 5:57 pm UTC

Version: 8.1.5 and Forms 6.0

Viewed 1000+ times

You Asked

Hi Tom,

I am very happy to inform that you had come early(One day ).
Now My company CEO wants to do a programm that read from MS-OUTLOOK messages from D2K Ver6.0 and insert into my Oracle Database 8i (8.1.5.
I would like to know how to read from MS-OUTLOOK and MS-ACCESS and How can I insert into my database.

Please give me some examples and where I can get more information.

Please keep in mind while giving answer, I am small person in "ORACLE REVOLUTIONARY WORLD"

Thanks in advance

Reddy

and Tom said...

This would not be easy to do from d2k.

This would be easy to do from Java.

To talk to an MS Exchange server (you will not be reading "outlook" messages -- outlook is an email CLIENT -- you will be getting the messages from the server which I assume is exchange in your case since everything else is MS based)....

Using the Java Mail API it is easy to read email from a variety of Email Servers. Using JDBC, it would likewise be easy to insert them into the database.

See
</code> http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:255615160805
for an example using Java to SEND (not recieve) email.  It is packaged into the database -- but that is not necessary.  It simply shows how you might use the Java Mail API from sun to do this.

See
http://java.sun.com/products/javamail/ <code>
for all of the details.


followup to comment

That is funny -- how are OLE and DDE "Oracle technologies"???

Java is (a technology embraced and supported by Oracle) -- OLE and DDE -- well, they are the property of another company (and a single company).

If the reader wants information on how to program OLE and DDE, Microsoft would be the correct place to go.

As I said in the answer, doing this in D2k would be *very hard*.
Doing this from the database using Java -- trivial.

If you read the link I provided, I show how to provide a very simple interface to java using PLSQL -- very simple. At the end of the day, the coders user PLSQL, not Java. The java is just there to read the mail.

If the people on site know OLE and DDE -- they should actually be able to answer this question then (i cannot, I never bothered to learn those two technologies myself - sorry)....

I try to give useful advice, better paths to take.

Rating

  (5 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, August 13, 2001 - 8:55 pm UTC

Since the question was how to read from Outlook, the response should of addressed this issue. Providing an alternative NON-Oracle solution had no value. Some of us are looking at DDE and OLE2. I have had limited success with this. I know that JAVA would also be a better interface; however, the client wants a ORACLE built in that is NOT JAVA because the client's in-house staff doesn't have enough experience with it to date.

:-)

Just another DBA, August 14, 2001 - 4:59 am UTC

The original response was excellent
The followup even better hope it cleared it up
for "reader"


Other methods......

DJG, August 15, 2001 - 9:01 am UTC

With 8.1.6 of Oracle, the Heterogeneous Services option (HS)
allows you to connect to an ODBC driver interface - provided you have these for your MS products you could examine this.
You can then write D2K or PL/SQL or SQL or whatever to use the HS database links to process the foreign data store.It's all documented in the manuals, at </code> http://docs.oracle.com <code>

Use perl

A reader, August 20, 2001 - 6:30 am UTC

You can download the MAPI module from activestate and do this thro' perl.

calling executable files from pl/sql block

v k ravi, July 21, 2006 - 2:59 am UTC

Hi tom

how r u?

i would like to know can i invoke a executable file of window as well as unix from pl/sql blocks.

thx

ravi

Tom Kyte
July 22, 2006 - 5:57 pm UTC

"r u"?

Rutgers University maybe? My girlfriend in high school/college attended there. A very fine University - spent a couple of weekends there myself.

</code> http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:952229840241#2717585194628 <code>

in 9i and before, the new scheduler package (documented) in 10g can do it as well.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library