Hi,

I am calling function which needs array as an input parameter. Can anyone help me on this.

My function is:

desc EMP_ID;
Argument Name Type In/Out Default
------------------------------ ------------------------------------------------------------------------- --------- -------
<return value> REF CURSOR OUT unknown
<none> Start_Date DATE IN unknown
P_ARRAY TABLE IN unknown

In this P_ARRAY is of type num_array.



My named query is
Query sampleQuery = DBHibernateConnection.getSession().getNamedQuery("sampleSP");
overlapCheckQuery.setDate("startDate", startDate);
overlapCheckQuery.setParameterList("empIdList", empIds);

Please suggest.