wood burning stoves 2.0*
The moose likes JDBC and the fly likes Help with Resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help with Resultset" Watch "Help with Resultset" New topic
Author

Help with Resultset

Chandra Chad
Greenhorn

Joined: Jan 04, 2001
Posts: 2
I am with SQL Server so far, which returns a results set when you call stored proc with query like "select * from table".
Is there a way I can get resultset to java by calling the stored proc?
If yes, can you give me an example of it.
Chandra
paul sun
Greenhorn

Joined: Dec 22, 2000
Posts: 28
Maybe its explanation and code can help: http://www.jguru.com/jguru/faq/view.jsp?EID=27825
And keep in mind that the returned result set is processed before INOUT or OUT if dealing some kinds of combo.

[This message has been edited by paul sun (edited January 04, 2001).]
Chandra Chad
Greenhorn

Joined: Jan 04, 2001
Posts: 2
Thanks paul,
but I missed typing Oracle at the end.
I am with SQL Server so far, which returns a results set when you call stored proc with query like "select * from table".
Is there a way I can get resultset to java by calling the stored proc written in Oracle?
If yes, can you give me an example of it.
Chandra

rgopi
Greenhorn

Joined: Jan 10, 2001
Posts: 9
Hi,
U can use CallableStatement for the same and use connection.prepareCall(SQLQuery) which returns
a result set.
Bye
Gopinath
------------
Originally posted by Chandra Chad:
I am with SQL Server so far, which returns a results set when you call stored proc with query like "select * from table".
Is there a way I can get resultset to java by calling the stored proc?
If yes, can you give me an example of it.
Chandra


Bye<BR>Gopinath
 
 
subject: Help with Resultset
 
Similar Threads
How resultset is returned by stored procedure?
getting ResultSet from Java Stored Procedure
How to pass Resultset as input parameter to a stored procedure ?
How to determine Primary Key of New Record
Data transfer between tables