调用存储过程问题

[古月书斋]

小弟写了如下代码:
public ResultSet viewProduct(String productid)
{ strSQL="{call view_product(?)}";
try
{
sqlStmt=con.prepareCall(strSQL);

sqlStmt.setString(1,productid);
result= sqlStmt.executeQuery(strSQL);

}
catch(Exception e)
{
System.out.print(e);
}
return result;
}
可是上面的代码出错说:java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Invalid call Statement method: {0}
我的存储过程在企业分析器中执行都没有问题的!

[sxl6159078]

oracle中作了一简单的存储过程：
create or replace procedure samp(i_name in char,i_ages in number) as
begin
delete from abcd;
insert into abcd values(i_name,i_ages);
commit;
end;

javabean中：

package tryexp.pro.bean;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;

public class insertPro implements java.io.Serializable{

public insertPro(){
}


public static void setDeathAge() throws SQLException{
Connection con = null;
CallableStatement proc = null;
try {
javax.sql.DataSource myDataSource = null;
Context ctx = null;
try {
ctx = new InitialContext();
myDataSource = (javax.sql.DataSource)ctx.lookup("wldatesource");
con = myDataSource.getConnection();
proc = con.prepareCall("{ call samp(?, ?) }");
proc.setString(1, "A01001");
proc.setInt(2, 28);
proc.executeUpdate();
}
finally {
try {
proc.close();
}
catch (SQLException e) {}
con.close();
}
}
catch (Exception e){
System.out.print("Connection Failed" + e.getMessage());

}
}

}