DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=DNxTw7u96e+d4y2YpRCHvSQ0tT+xjeLwRwDUy6DqBvDPqIjaxfVEE20s8CRu0U4Za6E3a7bqXSA5/k9mILzFLp6X+znXtmDGoQQDqetArJN42FJcgGaTNssJgavl8PZE4ht5D3qZgfcfPZwoPpHQmKbXP3nJFRE+6xFvifLZMp4=
Message-ID: <9177895d0712031853p2699a8d6of408e13c15c2005d@mail.gmail.com>
Date: Mon, 3 Dec 2007 21:53:32 -0500
From: rjamya <rjamya@gmail.com>
To: ryan_gaffuri@comcast.net
Subject: Re: returning a query as a pipeline function
Cc: oracle-l@freelists.org
In-Reply-To: <120320071717.1974.47543A2A000E3847000007B62207002953079D9A00000E09A1020E979D@comcast.net>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_10880_7446981.1196736812347"
References: <120320071717.1974.47543A2A000E3847000007B62207002953079D9A00000E09A1020E979D@comcast.net>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: rjamya@gmail.com
------=_Part_10880_7446981.1196736812347
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

The whole concept of pipelined function is to pipe the row as soon as it is
available ... so if you want, you can bulk collect it, but i'd rather pipe
it as soon as it is fetched inside your function.

developers using toad in production ... excellent.  just remember ot ensure
cs=exact in 9i ... else it might error out.

Raj
On Dec 3, 2007 12:17 PM, <ryan_gaffuri@comcast.net> wrote:

> we do not want to give developers direct access to query our data in
> production. For java developers we are simply returning a ref cursor. We
> have some other people who want to go into production with  Toad. Returning
> them a REF cursor requires them to write a bunch of code to parse the output
> and print it to the screen. So one option was to use a pipeline function.
>
> The developer then queries the pipeline function.
>
> All the examples I see involve some pl/sql loops that are piped back such
> as here:
>
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4447489221109
>
> do I need to
>
> select bulk collect into the object
>
> loop through the object and pipe it back row by row? Is there a better
> way?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
-----
Best regards
RJamya

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

<div>The whole concept of pipelined function is to pipe the row as soon as it is available ... so if you want, you can bulk collect it, but i&#39;d rather pipe it as soon as it is fetched inside your function.</div>
<div>&nbsp;</div>
<div>developers using toad in production ... excellent.&nbsp; just remember ot ensure cs=exact in 9i ... else it might error out.</div>
<div><br>Raj<br></div>
<div class="gmail_quote">On Dec 3, 2007 12:17 PM, &lt;<a href="mailto:ryan_gaffuri@comcast.net">ryan_gaffuri@comcast.net</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">we do not want to give developers direct access to query our data in production. For java developers we are simply returning a ref cursor. We have some other people who want to go into production with &nbsp;Toad. Returning them a REF cursor requires them to write a bunch of code to parse the output and print it to the screen. So one option was to use a pipeline function.
<br><br>The developer then queries the pipeline function.<br><br>All the examples I see involve some pl/sql loops that are piped back such as here:<br><br><a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4447489221109" target="_blank">
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4447489221109</a><br><br>do I need to<br><br>select bulk collect into the object<br><br>loop through the object and pipe it back row by row? Is there a better way?
<br><font color="#888888">--<br><a href="http://www.freelists.org/webpage/oracle-l" target="_blank">http://www.freelists.org/webpage/oracle-l</a><br><br><br></font></blockquote></div><br><br clear="all"><br>-- <br>-----<br>
Best regards<br>RJamya 

------=_Part_10880_7446981.1196736812347--
--
http://www.freelists.org/webpage/oracle-l