Return-Path: 
 <user-java-return-7208-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 37033 invoked from network); 25 May 2006 11:51:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 May 2006 11:51:29 -0000
Received: (qmail 73303 invoked by uid 500); 25 May 2006 11:51:28 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 72781 invoked by uid 500); 25 May 2006 11:51:26 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 72770 invoked by uid 99); 25 May 2006 11:51:26 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 May 2006 04:51:26 -0700
X-ASF-Spam-Status: No, hits=1.4 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_WHOIS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [209.73.178.226] (HELO web60818.mail.yahoo.com)
 (209.73.178.226)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 25 May 2006 04:51:26 -0700
Received: (qmail 79377 invoked by uid 60001); 25 May 2006 11:51:05 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=iLfz+9qcyirnj0lVsaDIuoha8IuwKW1WevilNNi3YMnf4yMnC4YgVZRI0YH1GI5xWGTYFRQlZZWDPwtucQ5D6I25G7GOuU73CR5cYvNALTLQtFnow1YLGZnX9+FkMrJwoAxopzAgvcBei+rLW+G1D/GQVW2GYKGGW19GG2HhBW4=
  ;
Message-ID: <20060525115104.79375.qmail@web60818.mail.yahoo.com>
Received: from [4.79.16.101] by web60818.mail.yahoo.com via HTTP;
 Thu, 25 May 2006 04:51:04 PDT
Date: Thu, 25 May 2006 04:51:04 -0700 (PDT)
From: Christina Xu <christxu@yahoo.com>
Subject: Re: Does IBatis support VARRAY output parameters for store procedure
 call?
To: user-java@ibatis.apache.org
In-Reply-To: <c593b8750605240731h689dc18di7d371699d47eb840@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

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