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
Joined: Dec 29, 2007
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()"