Oracle 使用Java Source 簡(jiǎn)單示例

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

       }
}

第二步：編輯存儲(chǔ)過(guò)程
create or replace procedure run_hello
as language java
name 'Hello.run()';

第三步：設(shè)置pl sql pluse
PL/SQL procedure successfully completed

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

Method called

第四步：運(yùn)行存儲(chǔ)過(guò)程
SQL> exec run_hello;

slc testing...

PL/SQL procedure successfully completed

SQL>

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]