Pass ArrayList To Oracle

[Mazen Mahmoud]

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?

[Agador Paloi]

I think the only way you can do this is to write the stored procedure in Java . Pl/ Sql cant process an Arraylist .

[Mazen Mahmoud]

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.

[sravani jetty]

Hi Mazen,

Can you give an example of how you used the ArrayDescriptor and passed the array elements?

Thanks