spring - Calling Oracle User defined function in Hibernate HQL -

spring - Calling Oracle User defined function in Hibernate HQL -

can help me here. want phone call oracle function in spring+hibernate application. how can done.

eg: oracle function olddata(varchar2 serialnumber) returns set of records having xyz fields. need phone call function in hibernate using hql. also, function have 2 tables in using bring together , records fetched both these tables.

regards, parichaya

i think this blog describes need. (basically need create own hibernate dialect - sounds scary @ first not big deal actually).

spring hibernate hql