Hi,

Is there a way of calling and getting a result from a DML:ing stored function (Oracle) with an EntityManager?

Plain ones I can do with createNativeQuery("select func() from dual") but DML:ing ones have to be called and I can't find any way of attaching to the result of an createNativeQuery("{?=call func()}"). I don't think the result mapping versions if createNativeQuery work either since there is no resulting column name to match to :-/

Getting the connection from the delegate doesn't work for me either as it closes my connection after execution when used in Seam

Surely someone has run such a function in this envireonment(?)

A RTFM-reference to a manual and a section number would be enough ;-)

It is kind of a show-stopper for my project rewrite right now...

Anyone? Either I'm going to win some award for the longest running monologue on this forum or then I'll get banned...