Re: Defining PL/SQL Table in a program

This is a multi-part message in MIME format.

--------------F39364788C12B5BB213D3030
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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

Jyothi

A table od records is only allowed in PL/SQL Ver 2.3 or later. Check yr pl/SQl Version.

-- 
Ajay Agrawal
Research Assistant
TTU Box 5997
Cookeville, TN 38505
Ph: (931) 372 2898(H)
    (931) 372 3341(O)

http://gemini.tntech.edu/~aka8369
--------------F39364788C12B5BB213D3030
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ajay Agrawal
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Ajay Agrawal
n:              Agrawal;Ajay
org:            Manufacturing Center
adr:            1210, Maddux Avenue;;;Cookeville;TN;38501;USA
email;internet: aka8369_at_tntech.edu
title:          Research Assistant
tel;work:       931 372 3341
tel;home:       931 372 2898
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------F39364788C12B5BB213D3030--