ORA-06502: PL/SQL: numeric or value error : ORA Error « System Packages « Oracle PL / SQL






ORA-06502: PL/SQL: numeric or value error

  

SQL>
SQL> DECLARE
  2    TYPE months_varray IS VARRAY(12) OF STRING(9 CHAR);
  3
  4    TYPE calendar_table IS TABLE OF VARCHAR2(9 CHAR) INDEX BY BINARY_INTEGER;
  5
  6    month MONTHS_VARRAY := months_varray('January','February','March','April','May','June','July','August','September','October','November','December');
  7
  8    calendar CALENDAR_TABLE;
  9  BEGIN
 10    IF calendar.COUNT = 0 THEN
 11      FOR i IN calendar.FIRST..calendar.LAST LOOP
 12        DBMS_OUTPUT.PUT_LINE('Index ['||i||'] is ['||calendar(i)||']');
 13      END LOOP;
 14    END IF;
 15  END;
 16  /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 11


SQL>

   
    
  








Related examples in the same category

1.ORA-00918: column ambiguously defined
2.ORA-00934: group function is not allowed here
3.ORA-00979: not a GROUP BY expression
4.ORA-01403: no data found
5.ORA-01403: no data found exception from procedure
6.ORA-01422: exact fetch returns more than requested number of rows
7.ORA-01426: numeric overflow
8.ORA-01839: date not valid for month specified
9.ORA-06502: PL/SQL: numeric or value error: character to number conversion error
10.ORA-06502: PL/SQL: numeric or value error: number precision too large
11.ORA-06503: PL/SQL: Function returned without value
12.ORA-14551: cannot perform a DML operation inside a query