E-mail from the server 
Author Message
 E-mail from the server
How can I send e-mail from a stored procedure in Oracle 8 or Oracle 8i?

-adhimas-



Wed, 18 Jun 1902 08:00:00 GMT
 E-mail from the server

There's a way to do this in Oracle8i i think... just havent
got around to actually using it yet...

However, you can visit our web site for a utility that
we use to send email via stored procedures. There's
even a test demo you can download to test with.

  http://hayden.home.mindspring.com

We have a number of online performance whitepapers and
stuff but just click the 'Tools' link for the email
utility.

peter

Quote:

>How can I send e-mail from a stored procedure in Oracle 8 or Oracle 8i?

>-adhimas-



Wed, 18 Jun 1902 08:00:00 GMT
 E-mail from the server
UTL_SMTP database package in Oracle 8.1.6


Quote:
> How can I send e-mail from a stored procedure in Oracle 8 or Oracle 8i?

> -adhimas-



Wed, 18 Jun 1902 08:00:00 GMT
 E-mail from the server
So, the Oracle itself doesn't have the ability to send e-mail. And we should
use third party program for e-mail. Am I correct?

-adhimas-


Quote:
> There's a way to do this in Oracle8i i think... just havent
> got around to actually using it yet...

> However, you can visit our web site for a utility that
> we use to send email via stored procedures. There's
> even a test demo you can download to test with.

>   http://hayden.home.mindspring.com

> We have a number of online performance whitepapers and
> stuff but just click the 'Tools' link for the email
> utility.

> peter


> >How can I send e-mail from a stored procedure in Oracle 8 or Oracle 8i?

> >-adhimas-



Wed, 18 Jun 1902 08:00:00 GMT
 E-mail from the server

Hi

You can use external procedure that sends your messages.
Look http://technet.oracle.com/sample_code/tech/pl_sql/listing.htm for
good examples. ( must be a member in OTN (free) )

rgrds
Kari Pannila
Oracle DBA

PS. Delete X from my mail address , it (X) is only for SPAMMERS.

Quote:

> So, the Oracle itself doesn't have the ability to send e-mail. And we should
> use third party program for e-mail. Am I correct?

> -adhimas-



> > There's a way to do this in Oracle8i i think... just havent
> > got around to actually using it yet...

> > However, you can visit our web site for a utility that
> > we use to send email via stored procedures. There's
> > even a test demo you can download to test with.

> >   http://hayden.home.mindspring.com

> > We have a number of online performance whitepapers and
> > stuff but just click the 'Tools' link for the email
> > utility.

> > peter


> > >How can I send e-mail from a stored procedure in Oracle 8 or Oracle 8i?

> > >-adhimas-

--


Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Storing emails in SQL Server

2. Access to email by SQL server 7.0

3. How to send email through smtp server?

4. Sending Email from SQL Server

5. Email and SQL Server 2000 (CDO vs MAPI)

6. CDONTS EMAIL FROM SQL SERVER 7.0

7. Sending Email via SQL server

8. Email from SQL Server 7

9. Extended procedure for SMTP email from SQL Server

10. emails through SQL SERVER PROCESS

11. Help: Internet Email enable SQL Server 6.5

12. Sending SSL Email From SQL Server


 
Powered by phpBB® Forum Software