Help - Search - Members - Calendar
Full Version: ORA-06502: PL/SQL: numeric or value error
Oracle DBA Forums > Oracle > Oracle Forum
jyothsna
Hi,
I tried the following query but getting the error:
Please hint me to solve the error.

CODE
DECLARE
  TYPE TYP_DUP1 IS TABLE OF DUP1%ROWTYPE;
   V_DUP1  TYP_DUP1;
BEGIN
  SELECT A
  BULK COLLECT INTO V_DUP1
  FROM   DUP1;
  
  FOR I IN V_DUP1.FIRST.. V_DUP1.LAST LOOP
    DBMS_OUTPUT.PUT_LINE(V_DUP1(I).A);
  END LOOP;
END;
/


But getting the following error:

************************
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 6
*************************
jyothsna
Hi friends,

I got the output.
The error is because there is no data in DUP1 table.

After inserting the records into that, i got the o/p with the program

Thankyou
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.