Re: Ref Cursors (weak)...how to declare a variable?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Sep 2000 19:26:58 +0100
Message-ID: <968783753.10529.0.nnrp-13.9e984b29@news.demon.co.uk>

You can't.

The weakly typed REF CURSOR could have ANY number of columns in its rowtype, so it is cannot have a %ROWTYPE.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Kelly wrote in message <8plb7r$d68$1_at_nnrp1.deja.com>...


>Hi All,

>

>Got a question....I'm experimenting with REF Cursors...and trying to

>declare a %ROWTYPE variable...but PL/SQL chokes up on it....how do you

>declare cursor variables for these?

>

>I'm trying something like

>

>TYPE curtype is REF CURSOR;

>c_target_table curtype;

>v_table_row c_target_table%ROWTYPE;

>

>It doesn't seem to like this.....any suggestions?

>

>TIA!!

>

>Kelly

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Tue Sep 12 2000 - 13:26:58 CDT