ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Does IBatis support VARRAY output parameters for store procedure call?
Date Wed, 24 May 2006 14:31:51 GMT
VARRAY is not a JDBC type - it is Oracle specific.  You might get this to
work by specifying the JDBC type of OTHER.  Then you can cast the returned
object yourself after iBATIS returns it.

Jeff Butler


On 5/24/06, Christina Xu <christxu@yahoo.com> wrote:
>
> Hello All,
>
> I wonder iBatis supports the store procedure call
> which has a out parameter of VARRAY. Please help.
>
> On store procedure side I have:
>
> create or replace TYPE myType is VARRAY(100) of
> VARCHAR(2).
>
> create or replace procedure MyProcedure(inParam IN
> DATE, outParam OUT myType) is .....
>
> On the sqlMap I have:
> <sqlMap>
> <resultMap id="procResultMap" class="MyResult">
>    <result property="dataName" column="MY_NAME" />
> </resultMap>
> <parameterMap id="procMap" class="Map" >
>    <parameter property="inParam" jdbcType="DATE"
> javaType="java.sql.Date" mode="IN" >
>    <parameter property="outParam" jdbcType="VARRAY"
> mode="OUT" >
> </parameterMap>
> <procedure id="doMyProc" parameterMap="procMap"
> resultMap="procResultMap">
>     { call MyProcedure(?,?)}
> </procedure>
> </sqlMap>
>
>
> At java code I have:
>
> ...
> map = new HashMap();
> map.put("inParam", new
> java.sql.Date(System.currentTimeMillis()));
> map.put("outParam",null);
> sqlClient.queryForList("doMyProc", map);
>
> I got the error message "register output parameters
> failed" , "Invalid column type".
>
>
> Please help. Thanks a lot !
>
> Chris
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

Mime
View raw message