Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

checking return status in stored procedures

 
Poornima Ganesh
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Iam using executeQuery() on a stored procedure . Iam getting errors like "No resultset for this query". My procedure doesnt return a resultset for the query at all times. So i need to check the return status of the query before i read the result set. Can anyone suggest me the method i have to use to check the return status of the procedure ?
Thanks for ur help.
 
sundari swamy
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Normally a error code "SQLCODE" would be returned. Depends on your database. It could be SQLCODE 100 ( this is for informix).
Which is for No data
what Db are you using?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic