CallableStatement doesn' execute nor fail
495419Mar 3 2006 — edited Mar 6 2006I have the followingo source to excecute a stored proc. in an orcla package. When I execute it from the SQLPLUS it works fine, but from java it doesn't do its work (generate some registers in the db). It doesn't throw an exception either so JDBC finds the procedure.
In SQLPLUS it stays 3 minutes executing but in java it is immediate.
There's a commit inside the proc.
Can anyone help me out why this can happen?
Thanks in advance.
------------------------------------
CallableStatement proc = bd.conexion.prepareCall("BEGIN SRH_ADMINIS.SRH_PQ_ATRASOS.SRHPR_CALC_ATRASOS_COLECTIVO(:1,:2,:3,:4); END;");
proc.setString(1, quien.substring(10,20));
proc.setString(2, quien.substring(0,2));
proc.setString(3, quien.substring(2,4));
proc.registerOutParameter(4,java.sql.Types.VARCHAR);
proc.setString(4, resultado);
proc.execute();
resultado = proc.getString(4);
proc.close();
----------------------------------------