From: sybrandb@yahoo.com
Newsgroups: comp.databases.oracle
Subject: Re: plsql.jar and JVM
Date: 15 Jul 2003 00:30:29 -0700
Organization: http://groups.google.com/
Lines: 19
Message-ID: <a1d154f4.0307142330.3f332966@posting.google.com>
References: <L2HQa.3116$104.264170@news20.bellglobal.com>
NNTP-Posting-Host: 145.13.42.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1058254229 28427 127.0.0.1 (15 Jul 2003 07:30:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 15 Jul 2003 07:30:29 GMT


"Jorge Pinto" <jorgep@sympatico.ca> wrote in message news:<L2HQa.3116$104.264170@news20.bellglobal.com>...
> Hello folks,
> 
> Why I have to install JVM and run plsql.jar to run UTL_SMTP ? What's the
> relation between UTL_SMTP and plsql.jar ?
> 
> Another question. What does plsql.jar contain ? I need to prove to the DBA
> that this is not going to have an impact to the database.
> 
> Thanks in advance.
> 
> JP

utl_smtp is only a wrapper for a java procedure. Need I say more.
And oh yes, you may need to check your DBA actually configured the
java_pool_size, or he is going to be in for some nasty surprises.

Sybrand Bakker
Senior Oracle DBA