oracle存储过程代用Java程序(单个main函数)
(1)连接数据库
sqlplus / as sysdba
(2)创建Java文件
A:创建
create or replace and compile java source named "javademo1"
as
import java.sql.*;
public class JavaDemo1
{
public static void main(String[] argv)
{
System.out.println("hello Oracle Test java demo1");
}
}
/
B:查看Java文件是否有错误
show errors java source "javademo1"
(3)创建调用Java程序的存储过程
A:创建
create or replace procedure javademo1
as
language java name 'JavaDemo1.main(java.lang.String[])';
/
B:查看是否有错误
show errors
(4)打开Oracle输出功能
set serveroutput on
(5)调用存储过程记录输出值
call javademo1();
call dbms_java.set_output(5000);
(6)界面输出结果
call javademo1();
hello Oracle Test java demo1
Call completed.
(1)连接数据库
sqlplus / as sysdba
(2)创建Java文件
A:创建
create or replace and compile java source named "javademo1"
as
import java.sql.*;
public class JavaDemo1
{
public static void main(String[] argv)
{
System.out.println("hello Oracle Test java demo1");
}
}
/
B:查看Java文件是否有错误
show errors java source "javademo1"
(3)创建调用Java程序的存储过程
A:创建
create or replace procedure javademo1
as
language java name 'JavaDemo1.main(java.lang.String[])';
/
B:查看是否有错误
show errors
(4)打开Oracle输出功能
set serveroutput on
(5)调用存储过程记录输出值
call javademo1();
call dbms_java.set_output(5000);
(6)界面输出结果
call javademo1();
hello Oracle Test java demo1
Call completed.