Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 84656 invoked from network); 25 Nov 2007 21:07:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Nov 2007 21:07:56 -0000 Received: (qmail 92642 invoked by uid 500); 25 Nov 2007 21:07:38 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 92627 invoked by uid 500); 25 Nov 2007 21:07:38 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 92616 invoked by uid 99); 25 Nov 2007 21:07:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Nov 2007 13:07:38 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of bhaarat.s@gmail.com designates 209.85.134.187 as permitted sender) Received: from [209.85.134.187] (HELO mu-out-0910.google.com) (209.85.134.187) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Nov 2007 21:07:18 +0000 Received: by mu-out-0910.google.com with SMTP id g7so550684muf for ; Sun, 25 Nov 2007 13:07:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=b/CoYZCHBL3Cru8nBsacYYsOur60l7Y0osT77yzO4tM=; b=TgJnOCHPX+U2sYjfOCVWJFVA7CtmsBSnSfQIILS59Ln0wjJWUBJvIz2dxsbHI+WfGDhfaZxSYPRn+ubmHsVADxXm7cSFtIsUI5ZMh/T1fyYDOXrESi/Db+WL1b8fGbpd4YR0YWTwpRCxHSwPz9JYaRyr2ga03SnO5+/mRZrHcfI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:mime-version:content-type; b=vHBb12w0DKZJBHV5qqEP1/l4YddoZXwOIeyYZN5tPYAFTjsfuBqyUCu1sCgJxcyaIHyFs5dkILjNq7io/c/nao+Au4YJaZ2pusd5zKrJMK5hiNLrXKdqPw0vEbq2eO1L0EwgyfdXDCauUg/iv0hhYeiw0dvmrWGOHV2ghjycjgQ= Received: by 10.82.107.15 with SMTP id f15mr5280026buc.1196024829374; Sun, 25 Nov 2007 13:07:09 -0800 (PST) Received: by 10.82.118.9 with HTTP; Sun, 25 Nov 2007 13:07:09 -0800 (PST) Message-ID: <491bd2b50711251307w122ace6bxb462f77d8b79b69a@mail.gmail.com> Date: Sun, 25 Nov 2007 16:07:09 -0500 From: "bhaarat Sharma" To: user-java@ibatis.apache.org Subject: iBatis with Oracle stored procs (multiple resultsets) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_43299_27354619.1196024829367" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_43299_27354619.1196024829367 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi I am fairly new to iBatis. We are currently using iBatis with java and MS sql server. Stored procedures returning multiple resultMaps is working fine for us right now. However, we are going to be switching to oracle soon and As you know oracle has RF Cursors when it comes to returning multiple resultsets from stored procs. I am just wondering if there are known problems with this approach ? I am going to be trying this very soon but just wanted to know if some of you out there are already aware of some known hiccups. Thanks -- -bhaarat ------=_Part_43299_27354619.1196024829367 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi

I am fairly new to iBatis. We are currently using iBatis with java and MS sql server. Stored procedures returning multiple resultMaps is working fine for us right now.

However, we are going to be switching to oracle soon and As you know oracle has RF Cursors when it comes to returning multiple resultsets from stored procs.  I am just wondering if there are known problems with this approach ?

I am going to be trying this very soon but just wanted to know if some of you out there are already aware of some known hiccups.

Thanks

--
-bhaarat ------=_Part_43299_27354619.1196024829367--