Re: Collection Help

From: dombrooks <dombrooks_at_hotmail.com>
Date: Thu, 15 Mar 2012 02:16:06 -0700 (PDT)
Message-ID: <26981688.4734.1331802966936.JavaMail.geo-discussion-forums_at_vblb5>

I admit I fired off my reply without even checking it, not having access to a db at the time, but I stand by it given there's no standalone test case and no indication of which is line 80.

SQL> DECLARE
  2 TYPE t1 IS TABLE OF NUMBER INDEX BY VARCHAR2(1);   3 v1 t1;
  4 BEGIN
  5 v1('A') := 1;
  6 FOR i IN v1.FIRST .. v1.LAST
  7 LOOP
  8 DBMS_OUTPUT.PUT_LINE(v1(i));
  9 END LOOP;
 10 END;
 11 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 6

SQL> DECLARE
  2 TYPE t1 IS TABLE OF NUMBER INDEX BY VARCHAR2(1);   3 v1 t1;
  4 idx VARCHAR2(30);
  5 BEGIN
  6 v1('A') := 1;
  7 idx := v1.FIRST;
  8 WHILE (idx IS NOT NULL)
  9 LOOP

 10       DBMS_OUTPUT.PUT_LINE(v1(idx));
 11       idx := v1.NEXT(idx);

 12 END LOOP;
 13 END;
 14 /
1

PL/SQL procedure successfully completed.

SQL> Received on Thu Mar 15 2012 - 04:16:06 CDT