function return cursor

How Do I use a cursor that return of a PL/SQL FUnction, into a SQL Stament? . I have Oracle 8i.
LVL 4
pbocanegraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RCorfmanCommented:
To my knowledge, this isn't possible. I've tried various ways to do it myself without success. Here is a link that confirms my thoughts.
http://www.experts-exchange.com/Databases/Oracle/Q_20864210.html

I will note that on 9i, it is possible to create a pipelined function that reads the cursor for you and returns the rows from the cursor, which you can then cast to a table and select from it, but if you are going to go through that, I'm not sure why you wouldn't just have the pipelined function open it's own cursor, doesn't seem much advantage to passing one in.

anyway, unfortunately, I don't believe you can do that.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.