使用select调用oracle函数,返回值的处理

Vector returned = BQueryClient.queryValueBySQL("select func_foo(a,b) from dual"); Hashtable table = (Hashtable)returned.get(0);//返回值是个放着table的vector BigDecimal dec = (BigDecimal)table.get("func_foo");//table里以函数名存放返回值,number型返回BigDecimal int value = -1; if(dec!=null) { value = dec.intValue(); }