This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes checking return status in stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "checking return status in stored procedures" Watch "checking return status in stored procedures" New topic
Author

checking return status in stored procedures

Poornima Ganesh
Greenhorn

Joined: Aug 16, 2001
Posts: 9
posted
0
Quote
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

Joined: Oct 19, 2001
Posts: 9
posted
0
Quote
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: checking return status in stored procedures
 
Similar Threads
cs.executeQuery() throws "Query returned no data" error
call a stored procedure using eclipselink Problem...
Result
getting ResultSet from Java Stored Procedure
Accessing Return Code Closes RecordSet?