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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Defining PL/SQL Table in a program

Re: Defining PL/SQL Table in a program

From: <mconnors_at_mother.com>
Date: 1997/09/24
Message-ID: <01bcc8a7$5e01c840$a52168cf@mconnors.mother.com>#1/1 







Pravin -



Prior to 7.3 (PL/SQL 2.3) it was not possible to declare a table of
records.  The %rowtype does not work because it really refers to a record.



You can work around this by declaring multiple tables, one for each element
of the record, and access each with the same index.  Not quite as
convenient, but not all that much trouble, either.



Regards,


Matt Connors
Received on Wed Sep 24 1997 - 00:00:00 CDT












Original text of this message













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