RE: Email from a trigger

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 but you'll also need to follow Jared's suggestion:

"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-----
Weinshenker
Sent: Wednesday, January 31, 2001 12:41 PM To: Multiple recipients of list ORACLE-L

Man, I feel like a complete dork.

I KNOW this has come up on the list before, and I thought I had saved it somewhere for if/when I would have to implement it...

yet here I am, needing to implement it, and unable to find the email

Anyone?

Thanks.

J

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Orr
  INET: sorr_at_arzoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).