Hi,
i have made stored procedure in oracle and try to run the output in the store procedure through IBATIS. The problem is i am having two output parameters and i want to execute it in the IBATIS
I am calling my procedure as
<parameterMap id="inputNewRegisterMap" class="newRegisterMap" >
<parameter property="StartDate" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="EndDate" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="lvocode" jdbcType="VARCHAR2" mode="IN"/>
<parameter property="outputnewRegister" jdbcType="ORACLECURSOR" mode = "OUT" resultMap = "spNewRegister" />
<parameter property="outputResults" jdbcType="VARCHAR2" mode = "OUT" resultMap = "spNewRegister" />
</parameterMap>
<procedure id="getNewRegistrationList" parameterMap="inputNewRegisterMap" resultMap = "spNewRegister">
{ call SP_NEWREGISTRATION(?, ?, ?, ?, ?) }
</procedure>
but while implementing it in dao i think i am not able to implement it properly
i am defining like
public NewRegistrations[] getNewRegistrationList(ReportRequest reportRequest)
{
NewRegistrations[] newRegistrations = null;
try
{
daoManager.startTransaction();
Map newRegisterMap = new HashMap();
newRegisterMap.put("StartDate",reportRequest.getFrmDate());
newRegisterMap.put("EndDate",reportRequest.getToDate());
newRegisterMap.put("lvocode",reportRequest.getLvoCodes());
queryForObject("getNewRegistrationList",newRegisterMap);
ArrayList lstnewRegister = (ArrayList) newRegisterMap.get("outputnewRegister");
lstnewRegister = (ArrayList) newRegisterMap.get("outputResults");
if(null != lstnewRegister)
{
newRegistrations = new NewRegistrations[lstnewRegister.size()];
}
for (int index=0; index < lstnewRegister.size(); index++)
{
newRegistrations[index] = (NewRegistrations) lstnewRegister.get(index);
}
}
finally
{
daoManager.endTransaction();
}
return newRegistrations;
{
NewRegistrations[] newRegistrations = null;
try
{
daoManager.startTransaction();
Map newRegisterMap = new HashMap();
newRegisterMap.put("StartDate",reportRequest.getFrmDate());
newRegisterMap.put("EndDate",reportRequest.getToDate());
newRegisterMap.put("lvocode",reportRequest.getLvoCodes());
queryForObject("getNewRegistrationList",newRegisterMap);
ArrayList lstnewRegister = (ArrayList) newRegisterMap.get("outputnewRegister");
lstnewRegister = (ArrayList) newRegisterMap.get("outputResults");
if(null != lstnewRegister)
{
newRegistrations = new NewRegistrations[lstnewRegister.size()];
}
for (int index=0; index < lstnewRegister.size(); index++)
{
newRegistrations[index] = (NewRegistrations) lstnewRegister.get(index);
}
}
finally
{
daoManager.endTransaction();
}
return newRegistrations;
, i want to define the second output parameter as i have bold it.plz suggest
Regards,
Puneet Arya
Yahoo! India Answers: Share what you know. Learn something new Click here
Catch all the FIFA World Cup 2006 action on Yahoo! India Click here
