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

Sending java List to oracle DataBase

 
Ali Al Ali
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,

I'm working with a project and I have some Issue,

I'm sending information to oracle as master and details (List Of Objects) and the List maight be 0 or more rows.

the stored procedure must receive a Collection of objects.

I need a code that send the details to the stored procedure to be stored in the Database

thanks in advance
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ana,
The following is not clear to me:

stored procedure must receive a Collection of objects

Since you say you are using an Oracle database, then your stored procedure is either implemented in PL/SQL or java.
If it is implemented in java then it must have a PL/SQL wrapper.
So are you saying that the stored procedure has a parameter which is an Oracle collection type, such as a VARRAY?
By the way, I could not ascertain from your post, the Oracle database version you are using.
You also asked:

I need a code that send the details to the stored procedure

Again I will ask for clarification.
Are you asking how to invoke your stored procedure using JDBC?

Good Luck,
Avi.
 
Ali Al Ali
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Avi,

Thanks a lot for the reply.

The stored procedure is made by an Oracle Developer in PL/SQL nad its as you said "Oracle collection type"

and I think it must call
"CallableStatement.setARRAY()" methd not "setArray()"

thanks again for help.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic