function return cursor

Posted on 2006-03-24
Last Modified: 2013-12-12
How Do I use a cursor that return of a PL/SQL FUnction, into a SQL Stament? . I have Oracle 8i.
Question by:pbocanegra
    1 Comment
    LVL 16

    Accepted Solution

    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.

    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.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now