Oracle 使用Java Source 简单示例

Oracle 使用Java Source 简单示例

第一步：创建java source
create or replace and compile java source named Hello
as
public class Hello{
       public static void run(){
              System.out.println("slc testing...");
       }
}

第二步：编辑存储过程
create or replace procedure run_hello
as language java
name 'Hello.run()';

第三步：设置pl sql pluse
PL/SQL procedure successfully completed

SQL> set serveroutput on size 5000;
SQL> call dbms_java.set_output(5000);

Method called

第四步：运行存储过程
SQL> exec run_hello;

slc testing...

PL/SQL procedure successfully completed

SQL>