Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Callable Statement with OUT parameter issue  RSS feed

 
Ganesh Gowtham
Ranch Hand
Posts: 225
IBM DB2 Eclipse IDE Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi

i have stored proc in DB2 which has 1 IN and 1 OUT parameter , also returns result set .

In java how can i access the same ( result set wont be returned ,incase validation fails ,in case of validation it returns the code in OUT param )

Thanks
 
Prabhakar Reddy Bokka
Ranch Hand
Posts: 198
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The out parameter would be a ResultSet.

Check if the Resultset updated with records after executing the CallableStatement.

If ResultSet is null throw an exception with validation error.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!