Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ref Cursors in 8i
Well, what exactly is working/not working ????
Are you saying the top one NOT work and bottom one DOES ???
How was "the_data" typed and declared ?
Michael Haggerty wrote in message ...
>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 - 17:53:28 CDT