Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ref Cursors in 8i

Re: Ref Cursors in 8i

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 11 Jun 2003 23:26:20 +0200
Message-ID: <ji7fevshag962il3779ld2j50cur4p8hmo@4ax.com>


On 11 Jun 2003 14:05:06 -0700, mhaggerty_at_mbda.gov (Michael Haggerty) wrote:

>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;

To get useful responses you need to post exact error messages for your first case.

>
>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

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 11 2003 - 16:26:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US