Re: Fetch limitations on a cursor

The numeric or value error has nothing to do with the amount of records returned. You are probably trying to return a varchar field from your cursor into a local variable of number or you are trying to read a large length variable varchar2(30) into a smaller length local variable of varchar2(25).

Recheck your code for any of these possibilities.

Mark

<sxbktm_at_my-deja.com> wrote in message news:7sof01$o5r$1_at_nnrp1.deja.com...
> Hi,
>
> I am a newbie in PL/SQL so please bear with me.
> What is the best way to fetch rows into a cursor. I have declared only
> one cursor that should theoretically fetch about a million rows into a
> cursor. Is that feasible.
>
> The reason I need to fetch all these rows is so that I can use some
> logic inside the loop. It essentially should update a column of a
> table based on the logic on some other columns. This works fine i a
> 1000 rows test data. But when I use this program for a million rows it
> says:
>
> DECLARE
> *
> ERROR at line 1:
> ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at line 26
>
> How do people normally do update a column for a huge number of rows if
> they have to manipulate values in the other columns.
>
> I can post the code if you are interested.
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Sep 28 1999 - 02:57:49 CDT