| 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: 1112
|
|
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.
|
 |
 |
|
|
subject: Sending java List to oracle DataBase
|
|
|