软件环境:
1、操作系统:Sun Solaris 10
2、数据库:Oracle 11g
实现方法:
1、创建一个文件为TEST.java
public class TEST
{
public static void main (String args[])
{
System.out.println("HELLO THIS iS A JAVA PROCEDURE");
}
}
2、javac TEST.java
3、java TEST
4、SQL> conn system/manager
SQL>grant create any directory to scott;
SQL> conn scott/tiger
SQL>create or replace directory test_dir as 'd:/';
目录已创建。
SQL>create or replacejava classusing bfile(test_dir,'TEST.CLASS')
2 /
Java已创建。
SQL> select object_name,object_type,STATUS from user_objects;
SQL>create or replace procedure test_java
as language java
name 'TEST.main(java.lang.String[])';
/
过程已创建。
SQL> set serveroutput on size 5000
SQL> call dbms_java.set_output(5000);
调用完成。
SQL>executetest_java;
HELLO THIS iS A JAVA PROCEDURE
PL/SQL过程已成功完成。
SQL>calltest_java();
HELLO THIS IS A JAVA PROCEDURE