JVM Hello World

[tekdudedude]

Hello,

I can see via the dba_registry that the JAVAVM (JServer JAVA Virtual Machine) is installed and VALID.

Can someone recommend a simple call I can run at the command line that tests the Java JVM inside the database (I am not a Java guy)?

From SQLPlus a SELECT sysdate FROM dual; does the trick for SQL.


Thanks,

TD

 

[tekdudedude]

I am plowing through the steps to understand how the JVM works in Oracle. For others looking for this:

create JAVA SOURCE NAMED "Hello" AS
public class Hello {
   public static String hello() {
   return "Hello World ";
   }
};
/

create or replace function Hello RETURN VARCHAR2 as LANGUAGE JAVA NAME 'Hello.hello() return String';

Usage: SELECT Hello.hello() FROM dual;

Does anyone know where the java source (JAVA SOURCE NAMED) is stored and how to get to it? It is not listed in SQLDeveloper. I am not sure of the dba_{view}.

Thanks,

TD

 

[jaxtell]

select * from user_source where type = 'JAVA SOURCE'

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/