Return-Path: Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org Received: (qmail 58645 invoked from network); 15 Aug 2006 17:59:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Aug 2006 17:59:48 -0000 Received: (qmail 21086 invoked by uid 500); 15 Aug 2006 17:59:48 -0000 Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org Received: (qmail 20911 invoked by uid 500); 15 Aug 2006 17:59:48 -0000 Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-cs@ibatis.apache.org Delivered-To: mailing list user-cs@ibatis.apache.org Received: (qmail 20899 invoked by uid 99); 15 Aug 2006 17:59:47 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Aug 2006 10:59:47 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [69.87.54.11] (HELO outbound-smtp.firstam.com) (69.87.54.11) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Aug 2006 10:59:45 -0700 Received: from 10.48.129.31 by outbound-smtp.firstam.com with ESMTP ( Hello SMTP Relay); Tue, 15 Aug 2006 10:59:19 -0700 X-Server-Uuid: 4892E436-2134-4AF3-ACFD-57F92EC383DC Received: from interactive-out.firstam.com (HELO FAIDHTC01SXCH01.fafiddom.com) ([10.176.18.103]) by FAEMSNA01SMXS01.firstam.com with ESMTP; 15 Aug 2006 10:59:19 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: Support for oracle cursors as resultsets Date: Tue, 15 Aug 2006 10:59:54 -0700 Message-ID: <751F0B5E81B1D3428FA924F462497A25029D9598@FAIDHTC01SXCH01.fafiddom.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Support for oracle cursors as resultsets Thread-Index: AcbAGLJz80WBllPUTnac2vHZl5q5CQAe61mg From: "Choi, Brian" To: user-cs@ibatis.apache.org X-TMWD-Spam-Summary: SEV=1.1; DFV=A2006081506; IFV=2.0.6,4.0-7; RPD=4.00.0004; RPDID=303030312E30413031303230342E34344532304141322E303035463A5343464D413534333432342D462D2F4E4553574B563534472F71554B6D71577A564237673D3D; ENG=IBF; TS=20060815175923; CAT=NONE; CON=NONE; X-WSS-ID: 68FCD4FD1W81587951-01-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6C094.9D3F5319" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C6C094.9D3F5319 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable This link helped me. (using ref cursor in Oracle) =20 http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pag eId=3D268 =20 Brian Choi =20 =20 =20 From: Clinton Begin [mailto:clinton.begin@gmail.com]=20 Sent: Monday, August 14, 2006 8:12 PM To: user-cs@ibatis.apache.org Subject: Re: Support for oracle cursors as resultsets =20 This is another thing we're planning on releasing in the Java version for 2.2.0. It wasn't terribly difficult to implement, and again, I could point you to the SVN log to see how we did it. How does the oracle driver return cursors? As a column with a value of type datareader?=20 Cheers, Clinton On 8/14/06, Choi, Brian wrote: Is this possible? It seems possible in Java version. Basically what I am trying to do is returning custom structure (oracle rowtype for example)=20 Or list of custom structure from stored procedure. =20 Brian=20 =20 =20 ------_=_NextPart_001_01C6C094.9D3F5319 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable

This link helped me. (using ref cursor in = Oracle)

http://opensource.atlassian.com/confluence/oss/pages/vi= ewpage.action?pageId=3D268

Brian Choi

From: Clinton = Begin [mailto:clinton.begin@gmail.com]
Sent: Monday, August 14, 2006 8:12 PM
To: user-cs@ibatis.apache.org
Subject: Re: Support for oracle cursors as = resultsets

This is another = thing we're planning on releasing in the Java version for 2.2.0. It wasn't = terribly difficult to implement, and again, I could point you to the SVN log to = see how we did it.

How does the oracle driver return cursors? As a column with a = value of type datareader?

Cheers,
Clinton

On 8/14/06, Choi, = Brian <bchoi@firstam.com> = wrote:

Is this possible? It seems possible in Java version.

Basically what I am trying to do is returning custom structure = (oracle rowtype for example)

Or list of custom structure from stored procedure.

Brian

------_=_NextPart_001_01C6C094.9D3F5319--