• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1619
  • Last Modified:

function return cursor

How Do I use a cursor that return of a PL/SQL FUnction, into a SQL Stament? . I have Oracle 8i.
0
pbocanegra
Asked:
pbocanegra
1 Solution
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now