venkat vanukuri

Greenhorn
+ Follow
since Mar 12, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by venkat vanukuri

I think you can pass collection as an object to calling client from Stored procedure. Its possible with Oracle data type CURSOR. example:

.
.
callStmt.registerOutParameter(index number, OracleTypes.CURSOR);
.
.
ResultSet rs = callstmt.getObject(index number);
while(rs.hasnext()){
// construct VO here
}
.
.
.
Hope it helps,
one more suggestion if you have to use Result Set,
try using rs = st.execute(); rather than boolean b = st.execute();.

Hope it helps.

Regards
Jayashree,

I guess one uses Result set to deal with objects returned. for example Oracle data type CURSOR.
In your case i see no reason to use result set.

I might be wrong.

Hope it helps