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.