Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!v2g2000hsf.googlegroups.com!not-for-mail
From:  Jake <jgarfield@earthlink.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: REF cursors vs. cursors
Date: Sun, 11 Nov 2007 15:32:19 -0800
Organization: http://groups.google.com
Lines: 30
Message-ID: <1194823939.681523.54310@v2g2000hsf.googlegroups.com>
References: <1194454196.943994.289110@i13g2000prf.googlegroups.com>
   <1194597321.354012.92390@o3g2000hsb.googlegroups.com>
NNTP-Posting-Host: 65.87.162.35
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1194823939 32475 127.0.0.1 (11 Nov 2007 23:32:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 11 Nov 2007 23:32:19 +0000 (UTC)
In-Reply-To: <1194597321.354012.92390@o3g2000hsb.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: v2g2000hsf.googlegroups.com; posting-host=65.87.162.35;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.server:437670
X-Received-Date: Sun, 11 Nov 2007 18:32:20 EST (text.usenetserver.com)

On Nov 9, 3:35 am, William Robertson <williamr2...@googlemail.com>
wrote:
> On Nov 7, 4:49 pm, Jake <jgarfi...@earthlink.net> wrote:
>
>
>
> > With cursors I could define a lot of my queries in the package
> > specification.  This is a convenient way to put queries in one place.
> > The parameterized cursor idea is nice too.  Plus it helps in not
> > writing the same query many times throughout the code.
>
> > What if I would like to do a similar thing, but I need to use REF
> > CURSORS strictly for the ability to be able to pass the ref cursor to
> > a procedure.  What's the preferred way of defining queries when using
> > REF CURSORS if I wanted to have a similar effect?
>
> > For example: Would it be feasible to define many VARCHAR2s that
> > represent queries in one package?  Or is there a way to associate REF
> > CURSORS with a regular cursor that's defined in a package?
>
> > What would be the preferred way to do this?
>
> > thanks.
>
> One approach might be to define packaged functions that returned ref
> cursors.


thanks.