Home -> Usenet -> comp.databases.oracle -> PL/SQL Help Request: Collections of Records

PL/SQL Help Request: Collections of Records

From: mblackwell264 <mblackwell264_at_cox.net>
Date: Sun, 21 Mar 2004 14:26:45 -0500
Message-ID: <10m7c.12909$1e1.6562_at_lakeread06> 





Platform:



     Oracle9i (9.2)



Data structures:


     TYPE mtyp_data_rec IS RECORD (
        field1   varchar2(10),
        field2   varchar2(13),
        field3   varchar2(11)
        ) ;

     TYPE mtyp_values_tab IS TABLE OF mtyp_data_rec ;

     ltbl_work_table     mtyp_values_tab := mtyp_values_tab() ;






Question:



     Could someone please give me an example of how to properly reference a
field from this table of records?



Thank you.



--Michael


   mblackwell_at_acm.org
Received on Sun Mar 21 2004 - 20:26:45 CET












Original text of this message