IN MY JDBC CODE EXCEPTION OCCURING ,procedure code is fine compiled & created ...exception isat oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleS
-
*************************my JDBC CODE ****************************** ***********using callable statement***************************** import A.JDBCUtil; import java.sql.*; import java.util.*; public class Test11 { public static void main(String[] args) { Connection con=null; CallableStatement cs=null; try{ int sid=96; con=JDBCUtil.getOracleConnection(); cs=con.prepareCall("call updateStudentData(?,?,?,?)"); cs.setInt(1,sid); cs.registerOutParameter(2,Types.INTEGER); cs.registerOutParameter(3,Types.FLOAT); cs.registerOutParameter(4,Types.CHAR); cs.execute(); System.out.println("procedure executed succesfully"); int t=cs.getInt(2); float a=cs.getFloat(3); String g=cs.getString(4); System.out.println("TOTAL"+t); System.out.println("average"+a); System.out.println("grade"+g); }catch(SQLException e){ System.out.println("EXCEPTION occur"); e.printStackTrace(); }finally{ JDBCUtil.cleanup(cs, con); } } } ************************my stored procedure code************************************************** create or replace procedure updateStudentData(id int,tot out int,ag out float,gd out char) as m1 number(3); m2 number(3); m3 number(3); begin select marks1,marks2,marks3 into m1,m2,m3 from students where sid=id; tot:=m1+m2+m3; ag:=tot/3; if (ag>=85.0) then gd:='A'; elsif(ag>=75.0)then gd:='B'; elsif(ag>=65.0)then gd:='C'; else gd:='D'; end if; update students set total=tot,average=ag,grade=gd where sid=id; end; /