Re: Defining PL/SQL Table in a program

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?
>
> I get the same error message even when I just have a simple
> declaration (without using record definitions) like:
>
> TYPE UsrTabTyp IS TABLE OF dbtable%ROWTYPE
> INDEX BY BINARY_INTEGER;
>
> Please email your suggestions to:
> nagaraj_jyothi_at_isus.emc.com
>
> Thanks,
> Jyothi

PL/SQL Tables for a single datatype are available on Oracle 7.2.

PL/SQL Tables of RecordTypes and Rowtypes are available only on Oracle 7.3 and later versions.

Fenella Received on Wed Sep 24 1997 - 00:00:00 CEST