Re: sending email in pl/sql

Ky,

Here is an example of a plsql procedure which sends email from the database if there is a problem with an Advanced Replication setup: http://www.dotcomsolutionsinc.net/products/repgen/repgen_example_repcheck_md ef1.html

Another method which could be used is to not use the Oracle database to send the email directly. The following Perl program queries primary and standby databases and makes use of the Mail::Sendmail Perl module to send an email if the standby database is not keeping up with the Primary database: http://www.dotcomsolutionsinc.net/products/installgen/installgen_win901_79_. html

You may download a demo version of Repgen or Installgen in order to create the same demo scripts you see on the web site. You can then modify these scripts for your own use if you like:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

David Simpson
www.dotcomsolutionsinc.net

"Ky" <keys_at_hongkong.com> wrote in message news:acie39$qdk$1_at_du05.ouhk.edu.hk...
> We are using 8.1.7 with Jserver options, after I have created the
necessary
> packages
> using the sample scripts from oracle otn, I try to send a email from
within
> pl/sql block
> and obtain the following error:
>
> Begin
> *
> ERROR at line 1:
> ORA-29540: class oracle/plsql/net/TCPConnection does not exist
> ORA-06512: at "SYS.UTL_TCP", line 537
> ORA-06512: at "SYS.UTL_TCP", line 199
> ORA-06512: at "SYS.UTL_SMTP", line 99
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at "ONRPROD.DEMO_MAIL", line 222
> ORA-06512: at "ONRPROD.DEMO_MAIL", line 99
> ORA-06512: at "ONRPROD.DEMO_MAIL", line 86
> ORA-06512: at line 2
>
> could someone pls advise what could possibly go wrong, is there
> any setting or step I have missed ??
>
> thx for the help
>
>
Received on Thu May 23 2002 - 09:39:20 CDT