Defining PL/SQL Table in a program

From: Pravin Sitaram <ink_at_tiac.net>
Date: 1997/09/23
Message-ID: <01bcc840$1e818c80$f20d77ce@pravin>#1/1

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 Received on Tue Sep 23 1997 - 00:00:00 CDT