RE: Send Message from the Oracle Database Unix mail, via PL/SQL

Have you considered using the Oracle supplied UTL_SNMP package? I did this and it's way cool. Oracle 8.1.6 or later is required. First you need to make sure the Oracle JVM is installed, (it's installed by default with 8.1.6). If it's not installed then follow the instructions on Metalink Doc 105472.1 Here's
a valuable tip I got from Jared Still:
"After running @?/javavm/install/initjvm, you will also need to run @?/rdbms/amdin/initplsj ( not documented )"

The UTL_SMTP package should already be installed on your system. Then just follow the instructions from Metalink Doc # 106513.1. BTW, they don't give good instructions on how to implement the plsql.jar. Here's what I did:
$ cd $ORACLE_HOME/plsql/jlib
$ loadjava -u system/password -v -r plsql.jar

The 106513.1. doc gives sample code to help you roll your own PL/SQL email package/procedure. That's all there is to it.

Have fun,
Steve Orr

-----Original Message-----
From: Garrity Ed R [mailto:Ed.R.Garrity_at_irs.gov] Sent: Thursday, September 28, 2000 11:31 AM To: oracledba_at_quickdoc.co.uk; 'oracle-l_at_fatcity.com' Subject: Send Message from the Oracle Database Unix mail, via PL/SQL

I'm looking for a way to send a message from the database server to unix mail, via PL/SQL. I'm not familiar with the DBMS_PIPE and DBMS_AQ packages, but I've begun to read the chapters in the "Oracle Built-In Packages" book. I'm wondering if the there is a utility, script, Oracle Bulletin, info, etc that already exists on this subject. And if someone could point me in the right direction. Received on Thu Sep 28 2000 - 13:59:47 CDT