How to integrate Oracle with e-mail?(m51)


In Sybase there are built in stored procs to handle email integration. To anyones knowlege does Oracle have something similiar. I am looking for something simple to integrate w/ SMTP or MAPI mail.  I remember seeing something in the docs, but forgot where.


Ans1:

Yes, Oracle has something similar.  In the ora_home/extproc directory of my
installation is a mailtest.dl (came with oracle)l that I use to send email
from within oracle stored procedures.



Ans2:

I'm sure this does not come with a standard Oracle Database. What other
Oracle Applications do you have ???  Oracle Office perhaps ??

We've had to write a 'C' dll, calling it from an external oracle procedure.



Ans3:

In 8i Oracle ships a COm cartridge which allows you to call com
servers from PL*SQL. This should make this job quite easy then.
 
 
 
 
 

Hosted by www.Geocities.ws

1