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

Home -> Community -> Usenet -> c.d.o.server -> Re: V$option displays Java parameter is false

Re: V$option displays Java parameter is false

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Jul 2002 23:01:23 -0700
Message-ID: <92eeeff0.0207282201.3a98edf9@posting.google.com>


"hund" <hunder_at_hotmail.com> wrote in message news:<QzC09.10915$DN4.2250722_at_news20.bellglobal.com>...
> Object_types do not have such JAVA% word, they onlu include such as table,
> view trigger and etc.
>

If you are referring to Oracle versions 8.0 and less, then you are correct but the original post says version 8.1.7. From releases 8.1 and above, you can install JVM (Java Virtual Machine) directly in the database giving you the functionality to create java stored procedures. You can install JVM by running ORACLE_HOME/javavm/install/initjvm.sql as SYS.

With JVM, you get two extra object_types i.e. "JAVA SOURCE" and "JAVA CLASS". "JAVA SOURCE" is like your .java file and "JAVA CLASS" is like your compiled .class file. You can compile java source outside of Oracle using JDK and then load the class file using loadjava utility, In this case you will only have "JAVA CLASS" object type. *OR* you can compile java class in the database by using (CREATE OR REPLACE AND COMPILE JAVA SOURCE...) command. This way you will have JAVA SOURCE and JAVA CLASS object types.

Most simple way to detect if JVM is installed in the database, you run the query as listed by Sybrand. If count 0 is returned, then JVM is not installed else you will recieve count of 6000+.

HTH
//Rauf Sarwar Received on Mon Jul 29 2002 - 01:01:23 CDT

Original text of this message

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