I am with SQL Server so far, which returns a results set when you call stored proc with query like "select * from table". Is there a way I can get resultset to java by calling the stored proc? If yes, can you give me an example of it. Chandra
Maybe its explanation and code can help: http://www.jguru.com/jguru/faq/view.jsp?EID=27825 And keep in mind that the returned result set is processed before INOUT or OUT if dealing some kinds of combo.
[This message has been edited by paul sun (edited January 04, 2001).]
Thanks paul, but I missed typing Oracle at the end. I am with SQL Server so far, which returns a results set when you call stored proc with query like "select * from table". Is there a way I can get resultset to java by calling the stored proc written in Oracle? If yes, can you give me an example of it. Chandra
Hi, U can use CallableStatement for the same and use connection.prepareCall(SQLQuery) which returns a result set. Bye Gopinath ------------
Originally posted by Chandra Chad: I am with SQL Server so far, which returns a results set when you call stored proc with query like "select * from table". Is there a way I can get resultset to java by calling the stored proc? If yes, can you give me an example of it. Chandra