Java开发网 - Java中调用存储过程问题

Java开发网

您没有登录

» Java开发网 » Java GUI 设计

打印话题 寄给朋友 订阅主题

作者

Java中调用存储过程问题

jessen4763

发贴: 2
积分: 0

于 2006-12-08 00:45

过程
create or replace procedure p_query(
p_name varchar2
)
is
v_player_name player.player_name%type;
v_player_id player.player_id%type;
v_player_sex player.player_sex%type;
v_player_age player.player_age%type;
v_team_id team.team_id%type;
v_team_name team.team_name%type;
v_team_loca team.team_loca%type;
begin
select p.player_name,p.player_id,p.player_sex,p.player_age,p.team_id,t.team_name,t.team_loca
into v_player_name,v_player_id,v_player_sex,v_player_age,v_team_id,v_team_name,v_team_loca
from team t,player p
where t.team_id=p.team_id
and p.player_name=p_name;
dbms_output.put_line(v_player_name);
Dbms_Output.put_line(v_player_id);
dbms_output.put_line(v_team_loca);
dbms_output.put_line('ok');
end p_query;

处理过程相关类
public class Dao {
  public List queryByName(String playerName) {
    Connection conn = DBHelper.getConnection();
    System.out.println(DBHelper.getConnection());
    CallableStatement cs = null;
    ResultSet rs = null;
    List list = new ArrayList();

    try {
      cs = conn.prepareCall("{call p_query Stupid

}");
      cs.setString(1, playerName);
      rs = cs.executeQuery();

      System.out.println(DBHelper.getConnection());

      System.out.println("JOE");
      while (rs.next()) {
        PlayerName player = new PlayerName();
        System.out.println("new");
        player.setPlayerName(playerName);
        player.setPlayerId(rs.getString(1));
        player.setPlayerSex(rs.getString(2));
        player.setPlayerAge(rs.getInt(3));
        player.setTeamId(rs.getString(4));
        player.setTeamName(rs.getString(5));
        player.setTeamLoca(rs.getString Devil

);
        list.add(player);
      }
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      try {
        if(conn!=null)
        conn.close();
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
    }
    return list;
  }
  public static void main(String[] args) {
    Dao dao = new Dao();
    List list = dao.queryByName("卡卡");
    System.out.println("OK");
  }
}

报错
acle.jdbc.driver.OracleConnection@26e431
JOE
java.sql.SQLException: ORA-00600: 内部错误代码，参数: [12259], [], [], [], [], [], [], []

  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
  at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
  at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:277)
  at com.thinkbank.dao.Dao.queryByName(Dao.java:29)
  at com.thinkbank.dao.Dao.main(Dao.java:58)
OK

话题树型展开

人气	标题	作者	字数	发贴时间
6299	Java中调用存储过程问题	jessen4763	2747	2006-12-08 00:45

已读帖子

新的帖子

被删除的帖子