Do not use on any
shared computer
August 29, 2008 08:05pm pdt
 
[x]
Attachment Details

How to page resultSet returned by Callable Statement

Tags: Sun, Java, 1.6, JDBC / Oracle
I'm using Callable Statement to call an Oracle store procedure but the resultSet is too big. Is there any way to page it? Is there any other way to call a store procedure and page the returned result if it's not possible with Callable Statement? Thanks!

Callablestatement cs = aConn.prepareStatement("{? = call pkg.sp(?,?,?)"});
ResultSet result=(ResultSet) cs.getObject(1);
Start your free trial to view this solution
Question Stats
Zone: OS
Question Asked By: musaka87
Question Asked On: 06.05.2008
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by schwertner

Rank: Wizard

Expert Comment by schwertner:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by contactkarthi
Expert Comment by contactkarthi:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628