hibernate調用oracle存儲過程||函數

pakeage dao.Impl;

//調用函數FUN_GET();

public String get(String Id,String Name){

return getSession().createSQLQuery("select FUN_GET(?,?) from dual")

.setParameter(0, Id).setParameter(1, Name).uniqueResult()

.toString();

}

//uniqueResult()  傳回唯一值

//調用存儲過程

CallableStatement call = connection.prepareCall("{call ?:=FUN_GETSTUNO(?,?)}");

call.registerOutParameter(1, Types.VARCHAR);

call.setString(2, Id);

call.setString(3, inDate);

call.executeQuery();