RE: #Adv#: returning a query as a pipeline function

["Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>]

There is alos the CAST method, but I'd think that a pipelined method
would be simpler.

______________________________________________________________
Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
Fax: 508.229.2019 /  Email: richard.goulet@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience 
______________________________________________________________


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
ryan_gaffuri@xxxxxxxxxxx
Sent: Monday, December 03, 2007 12:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: #Adv#: returning a query as a pipeline function

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:4447
489221109

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



This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient,  you are not authorized 
to read, print, retain, copy, disseminate,  distribute, or use this message or 
any part thereof. If you receive this  message in error, please notify the 
sender immediately and delete all  copies of this message.

--
http://www.freelists.org/webpage/oracle-l

Other related posts:

RE: #Adv#: returning a query as a pipeline function