Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pipelined Function vs Functions returning cursors

455943Sep 28 2005 — edited Sep 29 2005
Given a choice which could be better
a.Pipelined Function
b.Functions returning cursors

I guess functions returning cursors might cause problems since there is a max limit on the no. of cursors that can be simultaneously open.I dont much
about pipelined function.
Could somebody throw some light on this issue?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2005
Added on Sep 28 2005
8 comments
1,832 views