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.
Joined: Oct 19, 2001
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?