Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Executing a stored procedure returns false

 
Srikkanth Mohanasundaram
Ranch Hand
Posts: 241
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,

I'm using the following code to call a stored procedure and use the multiple result sets returned by the procedure.



The console prints false and i am unable to get the results.
The procedure as mentioned returns mutiple resultsets and I'm using Microsoft SQL server 2005. I did a call to this procedure from SQL editor and it works fine. Can someone let me know on what i am doing wrong here?

Thanks,
Srikkanth
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34094
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Srikkanth,
Does the stored procedure do any insert/update/deletes? If so, the stored procedure may be returning the # rows changed rather than the resultsets.
 
Srikkanth Mohanasundaram
Ranch Hand
Posts: 241
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes you are right. It does some delete of temporary tables. So how would i get the resultsets , is it not possible?

Thanks for your help,
Srikkanth
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34094
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Srikkanth Mohanasundaram wrote:Yes you are right. It does some delete of temporary tables. So how would i get the resultsets , is it not possible?

I would think it is possible. How to do so varies by database though. Conceptually, the stored procedure accumulates the result sets and returns them.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic