• Post Reply Bookmark Topic Watch Topic
  • New Topic

Executing a query using Callable statement  RSS feed

 
Chandra Bairi
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
dear friends,
how can we execute a query using a callable statement. normally we can execute a statement using statement or prepared statement. but how can we execute a query using normal callable statement.
thanks in advance.
shekar.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 36659
475
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chandra,
You would have to have a stored procedure containing the query you want to run. Then you could set up the parameters to pass the query (if any), run it and get the result back.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!