Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to call stored procedure with multiple in and out parameters using entity manager

 
Hardik Dhanuka
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are facing an issue while calling the stored procedure from the application.
The database is oracle 10g
This proc has 2 input parameters and 2 output parameters.

Input 1:- DB-List
Input 2:- String

Output 1:-Again a DB-List
Output 2:- Number

When we are trying to use
Query q = session.createSQLQuery("{call proc_name(?,?,?,?)}");
We cannot distinguish between in parameters and out parameters.
So how should we handle it by using this.

Also,
We tried to use callable statement as follows:-

We get the following error:-
javax.ejb.EJBException: java.lang.ClassCastException: $Proxy50 cannot be cast to oracle.jdbc.OracleConnection

Can you please provide some suggestions.

 
Bill Gorder
Bartender
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not sure what versions of things you are using. Have a look at this.
http://stackoverflow.com/questions/6707115/get-hold-of-a-jdbc-connection-object-from-a-stateless-bean
 
Hardik Dhanuka
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Bill,
We tried this using unwrap as well as session.doWork.
But its still giving us the error :-
This happens specifically when we try to get the connection for Array Descriptor.
 
Bill Gorder
Bartender
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You tried this?


From what was said it seems to be the recommended approach. Do you need the OracleConnection or can you make do with java.sql.Connection?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic