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

Home -> Community -> Usenet -> c.d.o.tools -> Ref Cursors (weak)...how to declare a variable?

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

From: Kelly <kgrigg_at_my-deja.com>
Date: Tue, 12 Sep 2000 13:31:38 GMT
Message-ID: <8plb7r$d68$1@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 - 08:31:38 CDT












Original text of this message













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