Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 24896 invoked from network); 3 Dec 2007 11:31:37 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 3 Dec 2007 11:31:24 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1B897CE1C8; Mon, 3 Dec 2007 12:30:05 -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 02284-06; Mon, 3 Dec 2007 12:30:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C6997CE253; Mon, 3 Dec 2007 12:30:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 03 Dec 2007 12:27:57 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A3397CE18E for ; Mon, 3 Dec 2007 12:27:57 -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 01999-08 for ; Mon, 3 Dec 2007 12:27:57 -0500 (EST) Received: from QMTA10.emeryville.ca.mail.comcast.net (qmta10.emeryville.ca.mail.comcast.net [76.96.30.17]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D46927CB50B for ; Mon, 3 Dec 2007 12:27:54 -0500 (EST) Received: from OMTA09.emeryville.ca.mail.comcast.net ([76.96.30.20]) by QMTA10.emeryville.ca.mail.comcast.net with comcast id LCsF1Y0050S2fkC0A0WB00; Mon, 03 Dec 2007 17:17:37 +0000 Received: from smailcenter60.comcast.net ([204.127.205.160]) by OMTA09.emeryville.ca.mail.comcast.net with comcast id LHHc1Y0073U9v2c0800000; Mon, 03 Dec 2007 17:17:37 +0000 X-Authority-Analysis: v=1.0 c=1 a=B84YIASkRjgA:10 a=KJUp47wO5OQZimnrE3dLWQ==:17 a=yPCof4ZbAAAA:8 a=j_wub98-loiOUNZnM7EA:9 a=YGYUG6xZ-hdZjTintSKCHZN-WesA:4 a=vVhpMayxIJQA:10 Received: from [12.109.140.115] by smailcenter60.comcast.net; Mon, 03 Dec 2007 17:17:31 +0000 From: ryan_gaffuri@comcast.net To: oracle-l@freelists.org Subject: returning a query as a pipeline function Date: Mon, 03 Dec 2007 17:17:31 +0000 Message-Id: <120320071717.1974.47543A2A000E3847000007B62207002953079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 X-archive-position: 3678 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-to: ryan_gaffuri@comcast.net 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 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