본문 바로가기
오류/Database

[Oracle] ORA-01008 : not all variables bound: 입력되어야 할 변수보다 적게 입력했나요?

by 희동츄루리 2023. 8. 9.
728x90
@Override
	public MemberDTO getMember(int num) {
		sql = "select * from member10 where num = ?";
		return this.template.queryForObject(sql, new RowMapper<MemberDTO>() {
			@Override
			public MemberDTO mapRow(ResultSet rs, int rowNum) throws SQLException {
				MemberDTO dto = new MemberDTO();
				dto.setNum(rs.getInt("num"));
				dto.setMemid(rs.getString("memid"));
				dto.setMemname(rs.getString("memname"));
				dto.setPwd(rs.getString("pwd"));
				dto.setAge(rs.getInt("age"));
				dto.setMileage(rs.getInt("mileage"));
				dto.setJob(rs.getString("job"));
				dto.setAddr(rs.getString("addr"));
				dto.setRegdate(rs.getString("regdate"));
				return dto;
			}
		}, num);
	}

넣어줘야 할 num 변수를 작성하지 않아 발생했다!