package hu.test;
import static org.junit.Assert.*;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Types;
import hu.db.OracleDatabase;
import org.junit.Test;
/* 存储过程 oracle调用 -----存储过程在数据库中
create or replace procedure proce_in(v_empno in emp3.empno%type,v_ename out emp3.ename%type)
as
begin
select ename into v_ename from emp3 where empno = v_empno;
dbms_output.put_line('名称是'||v_ename);
end;
//这是在数据库调用存储过程
// set serveroutput on;
// set verify off; 开启pl/sql客户端输出显示
declare
v_ename1 emp3.ename%type;
v_empno1 emp3.empno%type;
begin
v_empno1:=&empno;
proce_in(v_empno1,v_ename1);
dbms_output.put_line('名称是'||v_ename
import static org.junit.Assert.*;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Types;
import hu.db.OracleDatabase;
import org.junit.Test;
/* 存储过程 oracle调用 -----存储过程在数据库中
create or replace procedure proce_in(v_empno in emp3.empno%type,v_ename out emp3.ename%type)
as
begin
select ename into v_ename from emp3 where empno = v_empno;
dbms_output.put_line('名称是'||v_ename);
end;
//这是在数据库调用存储过程
// set serveroutput on;
// set verify off; 开启pl/sql客户端输出显示
declare
v_ename1 emp3.ename%type;
v_empno1 emp3.empno%type;
begin
v_empno1:=&empno;
proce_in(v_empno1,v_ename1);
dbms_output.put_line('名称是'||v_ename