Win a copy of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 this week in the Java in General forum!

emma Yao

Greenhorn
+ Follow
since Aug 03, 2006
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 emma Yao

When I tried to call a procedure which returns a cursor (the 5th param, refcursor type in oracle9i), I got an error(java.sql.SQLException: Invalid column index) when the execution went to line 'rs = (ResultSet)st.getObject(1);'. When I tested and execute the same procedure in SQLplus, I could get a result back (returns one record with 3 columns)Any suggestion and help will be greatly appreciated!

--------------------------------------------------
CallableStatement st = null;
ResultSet rs = null;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection db_conn = java.sql.DriverManager.getConnection ("");
st = db_conn.prepareCall("BEGIN packName.GETVENDORLIST(?,?,?,?,?); END; ");

st.setString(1,"1603DR");
st.setString(2,"06");
st.setString(3,"4160");
st.setString(4,"LA");
st.registerOutParameter(5,OracleTypes.CURSOR);

st.execute();
System.out.println("success execute");

rs = (ResultSet)st.getObject(1);

while (rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
[ August 03, 2006: Message edited by: Bear Bibeault ]