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
0
