sandeep pandey

Greenhorn
+ Follow
since Nov 09, 2001
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 sandeep pandey

Hi java gurus,
I'm using Websphere 3.5 standard edition with Oracle 8i as backend. I'm trying to access multiple resultsets thru oracle stored procedure.
-----------------------------
PROCEDURE add_Person (
pPersonId IN INTEGER,
pCountry OUT tCursor,
pPerson OUT tCursor) as

BEGIN
OPEN pCountry FOR
SELECT CTRY_CODE,DESC FROM COUNTRY;
OPEN pPerson FOR
SELECT * FROM PERSONS WHERE PERSON_ID = pPersonId;
END;
END;
---------------------
This procedure works well thru Oracle DBA Studio, but when I call it thru my java program,
-------------------------
Callable Statement stmt = connection.prepareCall("{call add_person(?,?,?)}");
stmt.setInt(1, pId);
stmt.registerOutParameter(2,OracleTypes.CURSOR);
stmt.registerOutParameter(3,OracleTypes.CURSOR);
stmt.execute();
ResultSet rs = ((OracleCallableStatement)stmt).getCursor(2);
----------------------
I get a ClassCastException at runtime at last line above.
If any body has ever worked on Websphere+Oracle8i with such kinda stored procedures (returninmg multiple resulsets), pls help me out of this trouble..
Thanks for your time
sandeep