Re: Java Stored Procedure Requirements

Matthias Rogel wrote:
>
> Jane O wrote:
> > How do I find out if I can do Java Stored Procedure on a server ?
> > thanks
> >
> >
> try it

Jane,
Allow me to try and give you a slightly more helpful reply than Matthias' reply.

I assume you're really asking how to find out if your Oracle database is java enabled (i.e. contains an embedded JVM). If this is what you are asking, then the best way I know, is to login to the database as user SYS (via SQL*Plus) and issue the following command:

desc dbms_java

If you get a list of methods and functions displayed on the screen, then your database is java enabled. If you get an error message, then your database is probably not java enabled.

If your database is not java enabled, you can install java by executing the "initjvm.sql" script as user SYS.

The location of the "initjvm.sql" script depends on your Oracle database version (which you didn't mention). On my 8.1.7.4 database (installed on a SUN [sparc]), the path is:

${ORACLE_HOME}/javavm/install/initjvm.sql

Of-course, all this (and more) is explained in the Oracle documentation, which is available from:

http://tahiti.oracle.com

And I hope this has helped you a bit more than Matthias's "try it".

Good Luck,
Avi. Received on Tue Nov 26 2002 - 00:23:58 CST