oracle调用java

 

select distinck owner.name from dba_source where lower(NAME)='dbms_java'

@?/
cd $ORACLE_HOME

cd javavm/install
initjvm.sql

select count(*) from dba_objects where object_type like '%JAVA%'

create or replace and complie java source named "JavaHello"
as
public class JavaHello{
 public static void main(String[] args){
	System.out.println("HelloWorld");
}

测试：show errors java source "JavaHello"

发布：
create or replace procedure javaFirstDemo
as
language java name 'JavaHello.main(java.lang.String[])';

call javaFirstDemo();

set serseroutput on;
call dbms_java.set_output(6000);


}

select object_name,object_type,status from user_objects where
object_type like '%java%'

java如何同时编译多个文件

cd \
javac com/test1/*.java


javac -d

jar  cvf test.jar .
loadjava -r -u scott/tiger /tmp