I have an ArrayList of java objects. I want to pass this ArrayList to an oracle stored procedure that will loop over the ArrayList, take objects, and insert objects' parameters to the database. Any Sample?
Joined: Jan 24, 2006
I think the only way you can do this is to write the stored procedure in Java . Pl/ Sql cant process an Arraylist .
Joined: Oct 25, 2007
Thanks for the reply. I've been able to solve it. I've used ArrayDescriptor from Java and array elements that i've sent to oracle procedure.
Joined: Jun 06, 2007
Can you give an example of how you used the ArrayDescriptor and passed the array elements?