Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with Resultset

 
Chandra Chad
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic