JPA, Oracle and stored procedures

[Curtis]

Is it possible to call stored procedures while using the JPA? If so,
does anyone know where I could find documentation? My searches have
turned up very little thus far.

Thanks in advance!

 

[Harry]

What do you mean by calling stored proc in JPA? Just like using
CallableStatement when using JDBC?

Harry

 

[sameerargade]

What do you mean by calling stored proc in JPA? Just like using
CallableStatement when using JDBC?

Harry

help me in this regard plz plz plz

 

[stefanomnn]

Hi,
this could help you: http://faqs.javabeat.net/ejb/enterprise_java_beans_ejb_interview_questions_8.php

or,in your session bean, try using method createNativeQuery in class
EntityManager.

i hope i helped you.
Stefano

 

[steve]

help me in this regard plz plz plz

yes it is , it is , it is.

however
A callable statement is not a callable procedure.

When calling a procedure in oracle you have to be clear is it a stored
procedure of pl/sql or a java stored procedure, the passing of types is
different.


Steve