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

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 28 Sep 2000 13:49:41 -0500
Message-Id: <10633.118172@fatcity.com>

	Here it is..
	Hope it helps..
	- Kirti
	-----Original Message-----
	From:	Steve Orr [SMTP:sorr_at_arzoo.com]
	Sent:	Wednesday, August 02, 2000 11:39 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: RE: Email from PL/SQL with Java - UTL_SMTP -

UTL_TCP         There's not much to share. 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-----

> From:	Garrity Ed R [SMTP:Ed.R.Garrity_at_irs.gov]

> Sent:	Thursday, September 28, 2000 1:31 PM

> 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:49:41 CDT