Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE Mailing
Zephyr wrote:
> We are running the follwing ORA Server:
>
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> With the OLAP and Oracle Data Mining options
> JServer Release 9.2.0.4.0 - Production
>
> Now I got the question, how can I bind the ORA Server to my SMTP
> Server, to send mails fired by a trigger. Is there an other possibilty for
> sending mails instead SMTP?
>
> Tanks for your answers and thougths
I suspect Oracle 'binds' to SMTP because they use the UTL_SMTP package they wrote. If that is not satisfactory, you could probably write your own package around their UTL_TCP or perhaps around UTL_FILE.
(All are described in the "Oracle9i Supplied PL/SQL Packages and Types Reference".)
Why is using SMTP a limitation or problem?
/Hans
ALso - please do not multi-post. Thx Received on Wed Oct 06 2004 - 07:51:24 CDT