passing a list to a stored procedure

[Raaja Gotluru]

Hi,

I have a situation where I need to pass a ArrayList object to a stored procedure which contains objects of hibernate pojos with values and iterate that in the stored procedure to insert the values and I am trying like this

List<PtRead> ptReadList = new ArrayList<PtRead>();

getTemplate().getSessionFactory().getCurrentSession().createSQLQuery("CALL PtRead_insert(:ptRead)").setParameterList("ptRead", ptReadList).executeUpdate();

This list might contain atleast 10000 records but in stored procedure I am not able to handle this list. If I give input parameter as of type object[] then I cant get values from the hibernate pojos. How to achieve this can anyone help.