Re: Java Stored Procedure Requirements

> The question was not if one can call a Java SP, but what are the
> prerequisites to be able to *create* one. Your approach will not
> work as you first have to create Java SP and only then you can
> try to call it - and if your Oracle instance is not Java-enabled, then
> you will fail on create step and will never come to trying that
> procedure. Avi gave correct answer to the original question, though
> there also is another way to verify if Oracle VM is ok:
>
> select count(*) from all_objects where object_type like 'JAVA%';
>
> should return more than 4000 (could be 9000+, depending on
> options loaded.) This query checks if JDK classes are all loaded
> and registered and is used internally in one of initjvm.sql
> subscripts for sanity check.
>

SQL> select count(*) from all_objects where object_type like 'JAVA%';

  COUNT(*)

     11478 Received on Tue Nov 26 2002 - 07:16:13 CST