java 调用存储过程出现"无效的索引列",请问怎么解决?
create or replace procedure class_course
is
cursor cur_a is select nianji from yxy_class;
cr yxy_class.nianji%TYPE;
begin
IF NOT cur_a%ISOPEN
THEN
OPEN cur_a;
END IF;
while cur_a%found
loop
fetch cur_a into cr;
end loop;
close cur_a;
end class_course;
proc = conn.prepareCall("{ call class_course() }");
proc.execute();
rs = (ResultSet)proc.getObject(1);
while (rs.next()) {
System.out.println("年级是="+rs.getObject("nianji") );
}
应该就是一列.但是在java里还是取不出来,出现"无效的列索引",这又是为什么呢?