Re: Defining PL/SQL Table in a program

From: Jerry Bull <Gerald.Bull_at_fmr.com>
Date: 1997/09/23
Message-ID: <3427F26D.4160@fmr.com>#1/1

Pravin Sitaram wrote:
>
> Hello,
>
> Within a procedure, I have defined a PL/SQL table of records as follows:
>
> TYPE UserRecTyp IS RECORD (
> fname varchar2(25),
> lname varchar2(25));
>
> TYPE UserTabTyp IS TABLE OF UserRecTyp
> INDEX BY BINARY_INTEGER;
>
> But, when I compile the above, I get the following error message:
>
> PLS-00507: PLSQL Tables may not be defined in terms of Records or
> other Tables
>
> What am I doing wrong here?

It looks like you are using a prior release of PL/SQL that didn't support record types in PL/SQL Tables.

Jerry. Received on Tue Sep 23 1997 - 00:00:00 CDT