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}"); 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); 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
|