Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 7547 invoked by uid 99); 8 Jan 2005 14:01:40 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of larry.meadors@gmail.com designates 64.233.184.206 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.206) by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 08 Jan 2005 06:01:37 -0800 Received: by wproxy.gmail.com with SMTP id 68so597256wri for ; Sat, 08 Jan 2005 06:01:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=qR26DRdLjt8MeCPN1WAAPpk9gZv2pFvoSF/8tGwTInBq+Ewuoh1vTqaSLvEYUI5NsUSchrO3jrz2NA6AyD9cwoAZ/NjRE6Tlv3d/rqjE0NCSmN+gPCr3kTbP1NF3YaZr7YChhdA5hOwrhQqkGAWz2KwvtTe2RjvsMoh3riOOO8s= Received: by 10.54.31.64 with SMTP id e64mr6517wre; Sat, 08 Jan 2005 06:01:35 -0800 (PST) Received: by 10.54.5.53 with HTTP; Sat, 8 Jan 2005 06:01:35 -0800 (PST) Message-ID: Date: Sat, 8 Jan 2005 07:01:35 -0700 From: Larry Meadors Reply-To: Larry Meadors To: ibatis-user-java@incubator.apache.org Subject: Re: Ref Cursor In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: X-Virus-Checked: Checked Yes, this is possible. At this point, the components to do it are still a bit fluid. I have a need to do this, too, so am trying to document how it all works. If you are interested in helping, there are a couple of threads that may be of interest to you: http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg00411.html http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg00269.html They are related to using oracle ref cursors with iBATIS. It looks like a couple of guys have gotten it working, and so it looks doable. Take a look, and see what you think of them. Also, if you (or anyone else) has time to help out with making this a more stable and documented pattern, it would be *greatly* appreciated. Anyone interested in helping with this can add to the wiki at: http://wiki.apache.org/ibatis/Database_20Specific_20Information Larry On Fri, 07 Jan 2005 17:28:11 -0300, Hernan BOYKIER wrote: > I'm trying to migrate from a legacy framework to iBatis. > The problem that I have is that all my business logic is written in Oracle > Stored Procedures. > They return a lot of parameters as Ref Cursors and with User Types. > Is it possible to handle this procedures with iBatis SQL Maps? > > Thanks, Hernan