Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: help with java stored proc--loadjava error: no such table MD5

Re: help with java stored proc--loadjava error: no such table MD5

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 10 Jul 2001 06:49:12 -0700
Message-ID: <9if14o03sr@drn.newsguy.com>

In article <5Hy27.324248$p33.6574288_at_news1.sttls1.wa.home.com>, "Greg says...
>
>I'm trying to get the simple hello, world Java stored procedure to work.
>I've got Oracle 8.1.7 client software installed with the Java goodies. I've
>got the latest JDK from Sun. My Java code compiles to a class file. But when
>I do this:
>
>loadjava -user me/pass_at_db.abcde.com -schema SSS -resolve -verbose
>hello.class
>
>I get four errors. As best I can tell the main problem is no MD5 table in my
>database, not in the SSS schema or anywhere else.
>
>I have regular user privileges, I'm not the DBA. I can create and run PL/SQL
>stored procedures with no problem.
>
>Is there some setup script or something the DBA has to run so I can create a
>Java stored procedure? Do I need some privileges that I don't have?
>
>I can't find any reference to this in the Oracle manuals.
>
>Thanks!
>
>Greg Jorgensen
>PDXperts LLC
>gregj_at_pdxperts.com
>
>
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:741025568112

the md5 table will be created for you (but you probably have a quota that does not permit this to happen)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Tue Jul 10 2001 - 08:49:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US