ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christina Xu <chris...@yahoo.com>
Subject Re: Does IBatis support VARRAY output parameters for store procedure call?
Date Thu, 25 May 2006 11:51:04 GMT
Hi, Jeff

I tried your suggestion, but I got the same error as:

"register output parameters failed" , 
"Invalid column type".

What I do wrong ? Any other options? Any documents or
examples that I can follow?

Thanks,
Chris


--- Jeff Butler <jeffgbutler@gmail.com> wrote:

> 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
> >
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Mime
View raw message