Re: pass List of objects as IN parameter to Stored Procedure

[Esperanza . Echeverria]

you have an example:


<parameterMap id="misParametros" class="java.util.HashMap" >
    <parameter property="parametro1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>    
  </parameterMap>
 <procedure id="ejecutaPKEjec" parameterMap="misParametros" >
    {call PKEjecSh(?)}
  </procedure>

 

Esperanza Echeverría de Miguel Steria España http://www.steria.es C/Menéndez y Pelayo,3 bis 46010 Valencia Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51 [EMAIL PROTECTED]

 

 

"chaithanya ibatis" <[EMAIL PROTECTED]> 11/07/2006 09:14 Please respond to user-java

To:        user-java@ibatis.apache.org         cc:                 Subject:        pass List of objects as IN parameter to Stored Procedure

HI,
I've been working with Oracle DB and iBatis
Can anyone tell me how to pass List of objects as IN parameter to Stored Procedure using iBatis
(mapping required in SQL map files of ibatis)
or any resources on this or code snippet


Thanks,
Chaithanya