- 论坛徽章:
- 0
|
存储过程接口
Salary(PJOB EMP.JOB%TYPE,PSCALE NUMBER,PCOUNT OUT NUMBER)
JAVA代码:
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection c = DriverManager.getConnection(dbUrl, user, passWord);
CallableStatement proc = c.prepareCall("{call Salary(?,?,?)}");
proc.setString(1,"CLERK");
BigDecimal a = new BigDecimal("0.0");
proc.setBigDecimal(2,a);
此行为报异常行:异常为无效的列索引
proc.registerOutParameter(3,Types.DECIMAL);
int b = proc.getInt(3);
proc.execute();
proc.close();
System.out.println(b);
} catch(Exception e)
{
System.out.println("ORCALE FOUND EXCEPTION");
System.out.println(e.toString());
}
}
如没有OUT参数,则正确执行,在网上查了一下,好象都是这么写的,不知道那里出现问题,请各位师兄,师姐指教,谢谢 |
|