Hi All,
I am using Hibernate 3.6.5, and using native sql to call a query. I am using the method session.createSQLQuery(finalquery);
My query has user defined functions in the query, something like "Select GETSUMMARYVIEWPARTIES(aoi.AOITARGETPFI),aoi.NAME from AOI aoi"
When I run this query in SQL client(squirrel) I get the required results but when I run it using hibernate session I get the below error.
"ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00904: "GETSUMMARYVIEWPARTIES": invalid identifier"

I would like to know if native sql creation in hibernate supports calling of user definer functions.

Regards