Defining PL/SQL Table in a program

Hello,

[Quoted] [Quoted] Within a procedure, I have defined a PL/SQL table of records as follows:

[Quoted] 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 CEST