如何从Java中调用Oracle函数?
我有一个Oracle函数aaa.fucntion(number, date),这个方法返回true或false。我该如何从Java中调用它并获取返回的值?
我正在使用Hibernate
这是我尝试过的:
Session session = null;
String associateHistorySQL="";
try {
session = HibernateUtil.currentSession();
associateHistorySQL = "SELECT aa.myFunction(:aorId,:givenDate) from dual";
Query associateHistoryQuery = session.createQuery(associateHistorySQL);
associateHistoryQuery.setParameter("aorId", associateOfficeRecordId);
associateHistoryQuery.setParameter("givenDate", date);
List associateHistoryList = associateHistoryQuery.list();
if (associateHistoryList != null && associateHistoryList.size() > 0 && new Integer(associateHistoryQuery.uniqueResult().toString()) > 0)
return true;
else
return false;
} finally {
HibernateUtil.cleanUpHibernateFromDao(false);
}
这是我收到的异常信息:unexpected token: aa: line 1:1: unexpected token: aa
谢谢。