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
paul sun
Greenhorn
Joined: Dec 22, 2000
Posts: 28
posted
0
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).]
Chandra Chad
Greenhorn
Joined: Jan 04, 2001
Posts: 2
posted
0
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
rgopi
Greenhorn
Joined: Jan 10, 2001
Posts: 9
posted
0
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
Bye<BR>Gopinath
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
