File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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.
OCA 8 book
How To Ask Questions The Smart Way
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-2015