Considering Hibernate is the default persistence provider, I would guess the OpenJPA forums will be more likely to provide a solution...
If I have to use the hibernate as my persistnce provider then will this procedure invocation is possible with IN OUT params?
I will check with the open jpa forums in the meanwhile.
Not sure if JPA supports out/inout parameters. I know I've used JDBC in similar cases.
That is possible using JDBC and I have achieved it.
The thing I am confused now is that since the project structure uses JPA and we have a limitation hitting the stored proc with in/out params using jpa, is it a good design
if I continue using JPA and invoke the stored proc using jdbc?
JPA 2.1 StoredProcedureParameter will support in/inout/out/ref_cursor, which will be part of EE7.