Re: Ref Cursors in 8i

mhaggerty_at_mbda.gov (Michael Haggerty) wrote in message news:<a83d9e3a.0306111305.7928f716_at_posting.google.com>...
> 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;
>

What is the definition (type) of "the_data"? Which specific errors are you getting?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed Jun 11 2003 - 22:40:26 CDT