Ref Cursors in 8i

From: Michael Haggerty <mhaggerty_at_mbda.gov>
Date: 11 Jun 2003 14:05:06 -0700
Message-ID: <a83d9e3a.0306111305.7928f716@posting.google.com>

Maybe I'm just having a bad day, but I am having a lot of trouble with reference cursors in 8i.

What I want to do is this:

PROCEDURE list_feeds(return_data IN OUT the_data) IS   BEGIN
    OPEN return_data FOR

      SELECT dm.din_name, df.feed_name 
      FROM DIN_MASTER dm, DIN_FEEDS df 
      WHERE dm.din_id = df.din_id;

  END list_feeds;   

But all I can get to work is this:

PROCEDURE list_feeds(return_data IN OUT the_data) IS   BEGIN
    OPEN return_data FOR

       SELECT * FROM DIN_MASTER;
  END list_feeds;   

These procedures appear in a package, and I know there is another way to write them. Can someone point me at how to do this?

M Received on Wed Jun 11 2003 - 16:05:06 CDT