Hallo,
well, I still think, my way also works.
Jane, I don't know what you want to do exactly, but
if you are using a language which supports exception-handling
(like PL/SQL, Java, Delphi, ...),
just do this:
Pseudocode
try
blablabla // invoke Java Stored procedure on server
exception // find out which exception to catch
when Java_Stored_procedure_on_server_is_not_supported then
error('Java Stored procedure on server is not supported');
end;
Matthias
Avi Abrami wrote:
> 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 - 01:14:09 CST
