Re: returning a query as a pipeline function
- From: rjamya <rjamya@xxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Mon, 3 Dec 2007 21:53:32 -0500
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, <ryan_gaffuri@xxxxxxxxxxx> wrote:
> 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?
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
-----
Best regards
RJamya
Other related posts:
