aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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: 1135

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Sending java List to oracle DataBase