Thanks for reply.
Below is our code:
createCallableStatement("{call PKG_WF_DASHBOARD_ROLLING.PRC_INITIAL_CUSTOMER(?,?,?,?,?)}");
int[] regionIds = formatIdArray(pRegionId, pRegions);
int[] stateIds = formatIdArray(pStateId, pStates);
int[] divisionIds = formatIdArray(pDivisionId, pDivisions);
int[] accountingUnitIds = formatIdArray(pAUId, pAccountingUnits);
System.out.println("Isnide the DAO pAUId----------"+ pAUId);
System.out.println("Isnide the DAO ----------"+ accountingUnitIds);
OracleCallableStatement find = (OracleCallableStatement)getCallableStatement();
find.setPlsqlIndexTable (1, regionIds, regionIds.length, regionIds.length, OracleTypes.NUMBER, 0); // regions
find.setPlsqlIndexTable (2, stateIds, stateIds.length, stateIds.length, OracleTypes.NUMBER, 0); // states
find.setPlsqlIndexTable (3, divisionIds, divisionIds.length, divisionIds.length, OracleTypes.NUMBER, 0); // divisions
find.setPlsqlIndexTable (4, accountingUnitIds, accountingUnitIds.length, accountingUnitIds.length, OracleTypes.NUMBER, 0); // accountingUnits
find.registerOutParameter(5, OracleTypes.CURSOR);
find.executeQuery();
if i remove cast i.e.
//OracleCallableStatement find = (OracleCallableStatement)getCallableStatement();
CallableStatement find = getCallableStatement();
then our code will not work because we are calling find.setPlsqlIndexTable() method which is in OracleCallableStatement class (oracle.jdbc.OracleCallableStatement).
Please help.
[Message sent by forum member 'mohang23']
http://forums.java.net/jive/thread.jspa?messageID=479505