java callable statment .next help
<p>I have this right now:</p>

<pre><code>public java.util.Vector getList() {

    java.util.Vector myuserList = new java.util.Vector();
    DbUtil db = null;
    java.sql.CallableStatement cstmt = null;
    ResultSet rset = null;


        db = new DbUtil();
        cstmt = db.prepareCall("{ call sample.user.get_user_list(?, ?, ?) }");

        cstmt.registerOutParameter(1,OracleTypes.CHAR);
        cstmt.registerOutParameter(2,OracleTypes.VARCHAR);
        cstmt.registerOutParameter(3,OracleTypes.CURSOR);

            cstmt.execute();

        }

        rset = (ResultSet) cstmt.getObject(3);
        if (rset != null) {
            while(rset.next()) {
                userBean myuser = new userBean();
                myuser.setuserid(rset.getString(1).trim());
                myuser.setuserName(rset.getString(2));


                myuserList.addElement(myuser);
            }
        }
                return myuserList;
             }
</code></pre>

<p>I want to get one more string ssn under my while(rset.next()).. when i just add this  <code>myuser.setuserSSN(rset.getString(3));</code> under  <code>myuser.setuserName(rset.getString(2));</code> its giving me error.. i have already updated my procedure to get user SSN so how can i get that ssn number here.. what do i have to modify.. one more thing i am getting all three userid, username and userSSN by using cursor <code>cstmt.registerOutParameter(3,OracleTypes.CURSOR);</code> first two callable statment are for exceptions in the procedure.. please help</p>

<p>here is the error i get..</p>

<pre><code>compile:
 [exec] com\javabean\userBean.java:188: cannot resolve symbol
 [exec] symbol  : variable myuser
 [exec] location: class com.javabean.userBean
 [exec]                                     myuser.setuserSSN(rset.getString(3));
 [exec]                                         ^
 [exec] 1 error
</code></pre>
