Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server with a Select * stored proc

 
Christian Schnepf
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a select * stored proc that I need to access from a jsp page. I am having difficulty setting up the output params and could use a little help. I dont get an error, but I do not get any data either.

Is there something wrong with my prepare or the registerOuts?

Table:


StoredProc:


JavaCode
 
David Yutzy
tumbleweed and gunslinger
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why wouldn't you just read the resulset instead of messing with out parameters?
 
Christian Schnepf
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have been unsuccessful finding any examples on getting out put from params or results sets for SQL Server.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic