Re: cursor fetching

Agoston Bejo wrote:

> Hi Daniel,
> the example you sent is fine, but it's quite a simple example.
> In my case, there's no table for the %ROWTYPE of which you could define a
> variable, since the columns it returns don't correspond to any table's
> rowtype. What to do then? And you don't know the rowtype of the cursor in
> advance, either. You only know that the columns in the cursor contain some
> of those relevant to your computations.
>
> Gus

You don't need a table for ROWTYPE. You can define individual variables, or you can define a cursor used only for purposes of defining a ROWTYPE, or you can create an array. There are lots of possibilities. Look at this page for examples:
http://www.psoug.org/reference/bulk_collect.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)