String sql = "{call SET_MTANKA (?, ?, ?, ?, ?, ?)}";
CallableStatement stmt = conn.prepareCall(sql);
stmt.setString(1, inpBean.getShime()); //inpBean.getShime()="0"
stmt.setString(2, inpBean.getKouku()); //inpBean.getKouku()="4"
stmt.setString(3, taisho); //taisho = "2008/03/01"
stmt.setTimestamp(4, target); //target = "2008/07/17"
stmt.setString(5, tancd); //tancd = "it"
stmt.registerOutParameter(6, Types.BIGINT); // Types.BIGINT = -5
// SP执行
stmt.execute();执行后就会出错 catch (SQLException sqle){
具体错误报的是 ora-20150 ora-06512
请问,哪里会出问题呢?
CallableStatement stmt = conn.prepareCall(sql);
stmt.setString(1, inpBean.getShime()); //inpBean.getShime()="0"
stmt.setString(2, inpBean.getKouku()); //inpBean.getKouku()="4"
stmt.setString(3, taisho); //taisho = "2008/03/01"
stmt.setTimestamp(4, target); //target = "2008/07/17"
stmt.setString(5, tancd); //tancd = "it"
stmt.registerOutParameter(6, Types.BIGINT); // Types.BIGINT = -5
// SP执行
stmt.execute();执行后就会出错 catch (SQLException sqle){
具体错误报的是 ora-20150 ora-06512
请问,哪里会出问题呢?
楼主【tjdghk】截止到2008-07-28 17:32:28的历史汇总数据(不包括此帖):
发帖的总数量:38 发帖的总分数:710 每贴平均分数:18
回帖的总数量:28 得分贴总数量:2 回帖的得分率:7%
结贴的总数量:30 结贴的总分数:550
无满意结贴数:6 无满意结贴分:200
未结的帖子数:8 未结的总分数:160
结贴的百分比:78.95 % 结分的百分比:77.46 %
无满意结贴率:20.00 % 无满意结分率:36.36 %
楼主加油
格式如下:
stmt.registerOutParameter(6, Types.ARRAY, "SET_MTANKA_LIST");
数据库的错误吧 oerr 查下就知道了