• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to return a table from MS SQL servers Stored Procd. to Java  RSS feed

Sagar Rohankar
Ranch Hand
Posts: 2907
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
Im new to JDBC and stored procedure
here is my problem : I want to return a table OR a select statement result ( which is table, as per my knowledge ) from MS SQL server`s Stored Procedure to my java app.

The select statement takes the result from other parameter which i passed to it at run time.. I used prepareStatement(? = call myProc( ? , ?)) , but what shud i take in first ? , so that i can iterate over it ( like a ResultSet ) and gets the values. It ll be very helpful if clear this with example ..

thankx in advance..
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!