RE: #Adv#: returning a query as a pipeline function
- From: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>
- To: <ryan_gaffuri@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 Dec 2007 14:00:56 -0500
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?
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: #Adv#: returning a query as a pipeline function
