RE: any dangers of using UTL

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 06 Jul 2001 12:10:09 -0700
Message-ID: <F001.003436F9.20010706122058@fatcity.com>

Sandesh,

It works fine with minimal impact. Once you install Java, be sure and run initplsj.sql in the ORACLE_HOME/RDBMS/ADMIN directory, or else the utl_smtp will not work.

If you follow the example in the docs for PL/SQL pre-defined procs, you should get the utl_smtp working just fine. If you have problems, drop me a line, and I will send you the stored procedure I use for the developers to call. I would suggest that you set this procedure up for them to use to make it easier for them, and for you to control the "From" address line.

That only thing I don't like about it this - you can put *anything* in the "from" area of the email address. Like: from Bill-Bob Bush, White House USA. It seems wrong to me but, what the hey.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, July 06, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L

Dear Friends,
I have a Oracle 8.1.6.2.0 database on HP-UX 11.0 of about 25M Shared pool about 10,000 db_block_buffers.
One of our development team wants to use UTL_SMTP. I know I have install Jserver and run initjvm.sql to install all the classes. I want to know any dangers or problems people have faced using this and what are the precautions they have taken. Steps to set up Jserver to UTL_SMTP to work smoothly are appreciated. All replies are welcome.

Thanks
Sandesh Naik
Oracle DBA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Naik, Sandesh S
INET: sandesh.naik_at_qwest.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: any dangers of using UTL_SMTP