Collections

From: Arthur <amerar_at_iwc.net>
Date: 21 May 2002 20:55:43 -0700
Message-ID: <8b622eae.0205211955.624e577f@posting.google.com>

Hello All,

What would be the major differences between a Collection and a simple PL/SQL array? I have this in my program, but cannot seem to use the FIRST and LAST functions on it.........

TYPE AuditTrlRec IS RECORD (

   batchnum VARCHAR2(5),
   trannum  VARCHAR2(6),
   seqnum   VARCHAR2(8),
   ph_key   NUMBER,
   dtbc     DATE);

TYPE AuditTrlTab IS TABLE OF AuditTrlRec index by binary_integer; v_AuditTrlData AuditTrlTab;

Thanks,

Arthur
amerar_at_iwc.net Received on Tue May 21 2002 - 22:55:43 CDT