Re: Equivelant of %Rowtype if the row structure does not exist in a table?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 25 Feb 2005 14:09:35 -0800
Message-ID: <1109369197.882773@yasure>

skull_leader7_at_yahoo.com wrote:

> What I need help on is in declaring the cursor type. Whereas for my
> existing function I declare the cursor type as:
>
> TYPE refcur_t IS REF CURSOR RETURN case_rec%rowtype;
Cursor(cursor(select * from case_rec)));

Defined your ref cursor as based on a cursor%ROWTYPE;

CURSOR mycur IS

SELECT ...
FROM ... a, ... b, ... c
WHERE a.id = b.id

AND a.id = c.id
AND ... TYPE refcur_t IS REF CURSOR RETURN mycur%ROWTYPE;

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

Received on Fri Feb 25 2005 - 16:09:35 CST