What is a pipelined function?

I need to use a stored procedure written by our DBA that he's calling a "pipelined function".

Please explain this. We work with Oracle, and the app I am supporting is MVC3 in C#.


Thanks.
newbiewebSr. Software EngineerAsked:
Who is Participating?
 
sdstuberCommented:
a pipelined function is a function that returns a collection type.
Sometimes called a "table function"  because you can query the function as if it were a table.


select * from table(your_function(1,2,3))


"pipelining" is a special way of returning the collection from inside the function.
rows will only be returned as they are needed.  As opposed to a non-pipelined function which will generate the entire collection and return all of it in one step.


http://download.oracle.com/docs/cd/E11882_01/appdev.112/e25519/tuning.htm#i53109


0
 
viralypatelCommented:
this url gives a detailed explanation of the pipelined functions:
http://www.oracle-developer.net/display.php?id=207
0
 
newbiewebSr. Software EngineerAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.