This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic