A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
this week in the
Executing a query using Callable statement
Joined: Sep 12, 2003
Feb 29, 2004 19:15:00
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.
author & internet detective
Joined: May 26, 2003
Mar 01, 2004 18:16:00
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.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Executing a query using Callable statement
Prepared Vs Callable statements
Function in Callable Statement
How resultset is returned by stored procedure?
Problem while executing Procedures Using Callable Statement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014