Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of fatboysuns@gmail.com
 designates 66.249.92.171 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=R9cIvHWIGwYUQEYJ8rlY8N0qBmx4h4xuj1g7XoKIKVo7fGTg7Wo6tizyd6mjMsg7hL
         WG/HiJSjNFoYjPJfKW4C70uIE2zKBJYId67HYY1HCjThSO60p1qW2LPccLACyxWoMS7c
         X5pw56jCV/K8eDv6I5dB1aye9OWQ54/zvM/Kc=
Message-ID: <d4ebe7ab0809120840o79090692qc45605e3add2f4df@mail.gmail.com>
Date: Fri, 12 Sep 2008 08:40:19 -0700
From: "Sundar Sankar" <fatboysuns@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: IBATI - PROCEDURE - RESULT SET - OUT PARAM
In-Reply-To: <19455910.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_128305_10233843.1221234019785"
References: <19455910.post@talk.nabble.com>

------=_Part_128305_10233843.1221234019785
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Please read the Ibatis documentation and you will find similar examples
there.

On Fri, Sep 12, 2008 at 6:33 AM, my screen1 <shiva.shankarp@target.com>wrote:

>
> Hi,
>
> I am calling a procedure from ibatis layer, where the procedure returns a
> result set ( as normal select ) and an output parameter.
>
> My procedure will be as below:
>
>  procedure test(count integer out)
>  {
>     select name,no from employee;
>     set count=select count(*) from employee;
>
>  }
> Could you plz help me in how to achieve this throuh Ibatis? Also how can I
> read that data in Java layer?
>
> Thanks
> Shiva.
> --
> View this message in context:
> http://www.nabble.com/IBATI---PROCEDURE---RESULT-SET---OUT-PARAM-tp19455910p19455910.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

------=_Part_128305_10233843.1221234019785
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Please read the Ibatis documentation and you will find similar examples there. <br><br><div class="gmail_quote">On Fri, Sep 12, 2008 at 6:33 AM, my screen1 <span dir="ltr">&lt;<a href="mailto:shiva.shankarp@target.com">shiva.shankarp@target.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Hi,<br>
<br>
I am calling a procedure from ibatis layer, where the procedure returns a<br>
result set ( as normal select ) and an output parameter.<br>
<br>
My procedure will be as below:<br>
<br>
 &nbsp;procedure test(count integer out)<br>
 &nbsp;{<br>
 &nbsp; &nbsp; select name,no from employee;<br>
 &nbsp; &nbsp; set count=select count(*) from employee;<br>
<br>
 &nbsp;}<br>
Could you plz help me in how to achieve this throuh Ibatis? Also how can I<br>
read that data in Java layer?<br>
<br>
Thanks<br>
Shiva.<br>
<font color="#888888">--<br>
View this message in context: <a href="http://www.nabble.com/IBATI---PROCEDURE---RESULT-SET---OUT-PARAM-tp19455910p19455910.html" target="_blank">http://www.nabble.com/IBATI---PROCEDURE---RESULT-SET---OUT-PARAM-tp19455910p19455910.html</a><br>

Sent from the iBATIS - User - Java mailing list archive at Nabble.com.<br>
<br>
</font></blockquote></div><br></div>

------=_Part_128305_10233843.1221234019785--