Re: Pro*C equivalent of PL/SQL pipelined function?

pbewig_at_swbell.net (Phil Bewig) wrote in message news:<455f7154.0406011053.50d52b_at_posting.google.com>...
> I am an experienced programmer in C and PL/SQL but not Pro*C.
> In PL/SQL, I could use a pipelined function to return a table,
> one row at a time, that could be used in the FROM clause of a
> SELECT query. Now I have a PL/SQL program that returns data
> via a pipelined function, but too slowly, and I am considering
> a rewrite in Pro*C for speed. What is the Pro*C equivalent of
> a pipelined function? And is my assumption of an order of
> magnitude speed improvement when moving from PL/SQL to Pro*C
> realistic?
>
> Many thanks,
>
> Phil

Your basic premise is unrealistic. Replacing PL/SQL by Pro*C would imply you are going to fetch your data to the client, and possibly send it back.
You should try to repair what looks like to be broken, not replace a Ferrari by a T-Ford.

Sybrand Bakker
Senior Oracle DBA Received on Wed Jun 02 2004 - 04:16:01 CDT