Oracle-L: RE: Error while invoking Email from PL/SQL

From: Rodrigues, Bryan <BRodrigues_at_elcom.com>
Date: Tue, 13 Aug 2002 13:44:59 -0800
Message-ID: <F001.004B3A76.20020813134459@fatcity.com>

Do you have java virtual machine installed? The package in the error it is looking for dbms_java is created during the initjvm.sql script. It looks like either jvm is not installed or failed during the install.

Bryan

-----Original Message-----
Sent: Monday, August 12, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L

Hi All,

I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).

I tried to run the initplsj.sql and got the following error.....

Can you guys tell me what should I do to correct this?

SQL> @initplsj.sql
call dbms_java.set_output(10000)

*
ERROR at line 1:
ORA-06576: not a valid function or procedure name

call dbms_java.loadjava('-resolve plsql/jlib/plsql.jar')

*
ERROR at line 1:
ORA-06576: not a valid function or procedure name

And then I tried to run
loadjava -user sys/*** plsql.jar, again to no avail....

Thanks in advance

K.
--

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

Author: karthikeyan S
INET: skarthik_at_globalsw-in.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: Rodrigues, Bryan
INET: BRodrigues_at_elcom.com

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