The moose likes JDBC and Relational Databases and the fly likes Sending java List to oracle DataBase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Sending java List to oracle DataBase" Watch "Sending java List to oracle DataBase" New topic
Author

Sending java List to oracle DataBase

Ali Al Ali
Greenhorn

Joined: Dec 29, 2007
Posts: 18
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


SCJP 1.4, SCWCD 1.4
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138
    
    1

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

Joined: Dec 29, 2007
Posts: 18
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sending java List to oracle DataBase
 
It's not a secret anymore!