null resultset

[JayaSiji Gopal]

I am calling a stored procedure from a java program as follows:

 
 
 CallableStatement st=null;
 ResultSet rs=null;
 ArrayList al= new ArrayList();
 
 try{
                st=con.prepareCall("{call VIVP538(?,?,?,?,?)}");
                st.setString(1,uniqueId);               //TODO check this
 
             logMan.info(mName, "first input param for VIVP538:::"+uniqueId+":");
 
                st.registerOutParameter(2,Types.CHAR);
                st.registerOutParameter(3,Types.INTEGER);
                st.registerOutParameter(4,Types.CHAR);
                st.registerOutParameter(5,Types.CHAR);
 
                boolean b = st.execute();
String outparam = st.getString(2).trim();
                logMan.info(mName, "after running VIVP538. status:::"+outparam);
 rs=st.getResultSet();
                logMan.debug("got the resultset");
 
                if(rs == null) {
                        throw new Exception("The resultset is null");
                }
                if(rs.next()){
                        logMan.info("inside the if loop");
                }
 
   } //end of try
finally {
   close the resultset, close the conn code
 
} 

When I run the Stored procedure, i get one record. The outparam in the above code also returns "SuCCESS". However, rs = st.getResultSet(), returns null.

What could be the reason? The same code, at exactly in a different method works perfectly fine.

Please assist.

[venkat vanukuri]

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

[venkat vanukuri]

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