Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 33612 invoked from network); 24 Apr 2010 08:33:40 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 24 Apr 2010 08:33:40 -0000 Received: (qmail 91663 invoked by uid 500); 24 Apr 2010 08:33:40 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 91504 invoked by uid 500); 24 Apr 2010 08:33:39 -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 91495 invoked by uid 99); 24 Apr 2010 08:33:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Apr 2010 08:33:39 +0000 X-ASF-Spam-Status: No, hits=0.9 required=10.0 tests=RCVD_NUMERIC_HELO,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gcjiu-ibatis-user-java@m.gmane.org designates 80.91.229.12 as permitted sender) Received: from [80.91.229.12] (HELO lo.gmane.org) (80.91.229.12) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Apr 2010 08:33:30 +0000 Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1O5anT-0002ae-PO for user-java@ibatis.apache.org; Sat, 24 Apr 2010 10:33:08 +0200 Received: from 211.186.198.152 ([211.186.198.152]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 24 Apr 2010 10:33:07 +0200 Received: from yjacket by 211.186.198.152 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 24 Apr 2010 10:33:07 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: user-java@ibatis.apache.org connect(): No such file or directory From: Alex Park Subject: Re: How to get a result from output =?utf-8?b?cGFyYW1ldGVyKFNZU19SRUZDVVJTT1Ip?= in iBATIS 3(by using annotation) Date: Sat, 24 Apr 2010 08:32:58 +0000 (UTC) Lines: 15 Message-ID: References: <4BD2699E.1080809@burntmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: sea.gmane.org User-Agent: Loom/3.14 (http://gmane.org/) X-Loom-IP: 211.186.198.152 (Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.1.249.1059 Safari/532.5) X-Virus-Checked: Checked by ClamAV on apache.org Thanks for your kindness and recommendation Guy, Actually, I didn't think that I had to use output parameter and ref cursor. Because stored procedures don't need any output parameter to get result sets in case of SQL Server. (SQL Server is major in-house DBMS) But Oracle stored procedure seems to need output parameter as ref cursor to get a result set. That is why I'm trying to use it. I got some questions from your answer. Is it possible to get a result set from SP without ref cursor? And what is the meaning of the simpler iBATIS functionality? Is it a map? or using query instead of SP? --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org For additional commands, e-mail: user-java-help@ibatis.apache.org