Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 93092 invoked from network); 26 Jul 2005 23:16:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 26 Jul 2005 23:16:06 -0000 Received: (qmail 71254 invoked by uid 500); 26 Jul 2005 23:16:05 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 71231 invoked by uid 500); 26 Jul 2005 23:16:05 -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 71218 invoked by uid 99); 26 Jul 2005 23:16:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Jul 2005 16:16:05 -0700 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 (asf.osuosl.org: domain of dhsilva@gmail.com designates 64.233.184.192 as permitted sender) Received: from [64.233.184.192] (HELO wproxy.gmail.com) (64.233.184.192) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Jul 2005 16:15:58 -0700 Received: by wproxy.gmail.com with SMTP id i27so54409wra for ; Tue, 26 Jul 2005 16:16:03 -0700 (PDT) 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:content-disposition:references; b=UzMgc/NEizZBXiBAOkx3LJc0l2KLywGVoK5lgsZ+UVy+cCAu1ipx04sGh9hZ41tb+2nguVT7LNT0DCFZ1ja8l31t6gMKl/5Y8H3l0eh+lfK06+odq9mQ5ZpoVj5HoXVW/GOi/q2ipHghfV/QuRbUKG8yYCZ/f0M4BYk4w+J/EcM= Received: by 10.54.35.54 with SMTP id i54mr96685wri; Tue, 26 Jul 2005 16:16:03 -0700 (PDT) Received: by 10.54.71.9 with HTTP; Tue, 26 Jul 2005 16:16:03 -0700 (PDT) Message-ID: <762ca9ae05072616167df022ab@mail.gmail.com> Date: Tue, 26 Jul 2005 20:16:03 -0300 From: Daniel Henrique Ferreira e Silva Reply-To: Daniel Henrique Ferreira e Silva To: user-java@ibatis.apache.org Subject: Re: InOut param problem with oracle In-Reply-To: <20050726161829.28467.qmail@smtp.qnet.com.pe> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <41314DDCD3F8D2119F6400A0C9F285F10A28F913@US-PB-XMSG-1> <20050726161829.28467.qmail@smtp.qnet.com.pe> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Wilberto, It seems that you are not using only primitive types on your stored procedure, so i think it'd be necessary to use Custom Type Handlers. Guess this wiki note may help you in some way: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+= a+Custom+Type+Handler+with+complex+property+or+Type+Safe+Enumeration Cheers, Daniel Silva. On 7/26/05, wilberto wrote: > I have this insert procedure with subtypes: >=20 > PROCEDURE SAV( > P_per_nid_Persona INOUT ST_per_nid_Persona, > P_per_nid_Nacionalidad IN ST_per_nid_Nacionalidad, >=20 > .... more fields... >=20 > P_IndicadorInfractor IN ST_IndicadorInfractor, > P_TIP_OPE IN VARCHAR2, > R_RESULT OUT refcur_type); >=20 > Inside the procedure get a secuence to P_per_nid_Persona (Integer) and re= tur > the value to java, but in practice no error was found and no value for > P_per_nid_Persona (R_RESULT cursor is fine) . How i can solve this proble= m? >=20 > Thank You. >=20 > Wilberto >=20 >=20 > --------------------------------------------------------------- > EC Red Internet gr@tis > Inscr=EDbete en www.ec-red.com >