Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 12395 invoked from network); 4 Dec 2007 14:39:41 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 4 Dec 2007 14:39:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 025CD7D17B0; Tue, 4 Dec 2007 15:39:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30969-05; Tue, 4 Dec 2007 15:39:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C1427D1772; Tue, 4 Dec 2007 15:39:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 04 Dec 2007 14:52:39 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 51B377D0DE0 for ; Tue, 4 Dec 2007 14:52:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19342-01 for ; Tue, 4 Dec 2007 14:52:39 -0500 (EST) Received: from web53910.mail.re2.yahoo.com (web53910.mail.re2.yahoo.com [206.190.36.220]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 056377CF0BE for ; Tue, 4 Dec 2007 14:52:38 -0500 (EST) Received: (qmail 34578 invoked by uid 60001); 4 Dec 2007 19:52:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Y97ibaxtbCsNKAGkPrp1m2YglOu5gdsQ+eWcxZoh+sTb8QL1izqr0oeu4pQkAKBO+KrQzcVUh8LRdrTIiaBvVRAKTYotDasKty8SvmsTjOOeGSjb3q1LYlkvRh5B/DRJVWidy7Xq91s2lKzfK70iU1jwhUEH4TCnIpiq65iscfs=; X-YMail-OSG: Keon4vYVM1kC68kTRGKNXi3g_lpn7CF8tS0OGfnawlugzZID2hmBuWOvllBzMdLTDz9uqcRAVHGSIScu_1L5ty_45nL.KkKp.Ggu8ctfMWarDO6ayYLtrLPG4YtwHTMk9gg_HZMryD3s7OB2VHYjrpqpOayS5YAXzO.eXVUsPXc- Received: from [148.87.1.170] by web53910.mail.re2.yahoo.com via HTTP; Tue, 04 Dec 2007 11:52:38 PST Date: Tue, 4 Dec 2007 11:52:38 -0800 (PST) From: Job Miller Subject: Re: returning a query as a pipeline function To: william@williamrobertson.net, oracle-l@freelists.org In-Reply-To: <47551289.6030002@williamrobertson.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-672543401-1196797958=:34524" Message-ID: <43960.34524.qm@web53910.mail.re2.yahoo.com> X-archive-position: 3699 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jobmiller@yahoo.com Precedence: normal Reply-to: jobmiller@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --0-672543401-1196797958=:34524 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If you want to see an end-to-end example from an external table out through the pipeline function, do a little more reading on asktom. here is the full example, where he fetches row by row.. explicit fetches though. nothing wrong with the implicit cursor for loop as William suggested also. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:19481671347143 William Robertson wrote: In 10g you might as well get the rows via a Cursor FOR loop so it's an implicit bulk collect. http://forums.oracle.com/forums/thread.jspa?threadID=592578 -----Original message----- From: rjamya Date: 4/12/07 02:53 > 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, > > wrote: > > 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 --------------------------------- Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. --0-672543401-1196797958=:34524 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If you want to see an end-to-end example from an external table out through the pipeline function, do a little more reading on asktom. 

here is the full example, where he fetches row by row.. explicit fetches though.  nothing wrong with the implicit cursor for loop as William suggested also.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:19481671347143


William Robertson <william@williamrobertson.net> wrote:
In 10g you might as well get the rows via a Cursor FOR loop so it's an
implicit bulk collect.
http://forums.oracle.com/forums/thread.jspa?threadID=592578

-----Original message-----
From: rjamya
Date: 4/12/07 02:53
> 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,
> > wrote:
>
> 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



Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. --0-672543401-1196797958=:34524-- -- http://www.freelists.org/webpage/oracle-l