JAVA代码
CallableStatement callstatement =connection.prepareCall("{call sp_pro(?,?)}");
callstatement.setInt(1, 10);
callstatement.registerOutParameter(2, oracle.jdbc.OracleTypes.CURSOR);
//得到结果姐
ResultSet rs= (ResultSet) callstatement.getObject(2);
while(rs.next()){
System.out.println(rs.getInt(1)+"用户名:"+rs.getString(2));
}
存储过程如下
create or replace procedure sp_pro18(spNo in number,p_cursor out testpackage.test_cursor) is
begin
open p_cursor for select * from emp where deptno=spNo;
end;
eclipse报错无效索引在
ResultSet rs= (ResultSet) callstatement.getObject(2);无效索引 存储过程
CallableStatement callstatement =connection.prepareCall("{call sp_pro(?,?)}");
callstatement.setInt(1, 10);
callstatement.registerOutParameter(2, oracle.jdbc.OracleTypes.CURSOR);
//得到结果姐
ResultSet rs= (ResultSet) callstatement.getObject(2);
while(rs.next()){
System.out.println(rs.getInt(1)+"用户名:"+rs.getString(2));
}
存储过程如下
create or replace procedure sp_pro18(spNo in number,p_cursor out testpackage.test_cursor) is
begin
open p_cursor for select * from emp where deptno=spNo;
end;
eclipse报错无效索引在
ResultSet rs= (ResultSet) callstatement.getObject(2);无效索引 存储过程
java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 2
PLS-00201: 必须声明标识符 'SP_PRO'
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored