Any LIMIT defined on looping index parameter?
902880Nov 30 2011 — edited Dec 1 2011Hi,
Therez one procedure in my DB which loops thru' a num range(i/p param).. does some logical operation.. and then inserts these values into a table..
It worked fine when a smaller range was passed. But if the range is increased to 11 digits it throwing the error - "ORA-01426: numeric overflow"
Extract of the code where its failing:-
BEGIN
FOR I IN 10010010010+1 .. 10010010013
LOOP
DBMS_OUTPUT.PUT_LINE(I);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
Can any lemme know plss if there is any limit defined on the looping index parameter?
Thanks,
Sujana