I have the same problem, except using EJB 3.0.
Have you solved this?
Also you can create your own stored procedure and use it.
Thank for your posts. At the end I just used different queries checking for specific integer values. Fortunately there wasn't that much.
Do you know how to define user function in Oracle Toplink instead of Hibernate?
Thanks for answers. Useful.
I'm using EntityManager methods createQuery and createNamedQuery.
So I need to define user function for JPQL (EJB QL) query or named query.
May be you know how can I do it?