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
posted 8 years ago
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.
SCJP 1.4, SCWCD 1.4
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads