a related question, may I pass a resultset through a out parameter?
Re: Statements works different than CallableStatement Author: sharan yadrami (http://www.jguru.com/guru/viewbio.jsp?EID=1045060), Sep 12, 2003 Hai Auro I have the same problem.Can u help me out if u have got the answer.It is very urgent. my code goes like this my code goes like this import oracle.jdbc.*; import java.sql.*; import javax.sql.*; class TestProcedure { public static void main(String args[]) { TestProcedure test = new TestProcedure(); test.Test(); } public void Test() { java.sql.CallableStatement cstmtObject = null; java.sql.ResultSet rulesObject = null; try{ String conStr = “jdbc:oracle:thin:@172.20.10.7:1521:BAS”; String user = “test”; String pass = “test123”; DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); java.sql.Connection conn = (java.sql.Connection)DriverManager.getConnection(conStr,user,pass); System.out.println(“connected”); String sqlquery = “{call test.COMPUTATION(?,?,?,?)}”; cstmtObject = conn.prepareCall(sqlquery,ResultSet.TYPE_SCROLL_INSEN
