| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: #Adv#: returning a query as a pipeline function
There is alos the CAST method, but I'd think that a pipelined method would be simpler.
Together: the Collaborative Business Experience
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
ryan_gaffuri_at_comcast.net
Sent: Monday, December 03, 2007 12:18 PM
To: oracle-l_at_freelists.org
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
Received on Mon Dec 03 2007 - 13:00:56 CST
 |
 |