Re: Cursor script hangs in loop

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/03/05
Message-ID: <6dlma8$ftr$3@news00.btx.dtag.de>#1/1

On Wed, 04 Mar 1998 17:00:57 -0800, Jim Lake <jimlake_at_home.com> wrote:

Hi,

try:
DECLARE
 JIM_COUNTER NUMBER(10) := 0;
 CURSOR COUNT_CURSOR IS
  SELECT REC_KEY FROM TEST_COUNTER ;
BEGIN

	FOR TESTROW in COUNT_CURSOR LOOP
		 JIM_COUNTER := JIM_COUNTER + 1;
  		 UPDATE TEST_COUNTER SET REC_KEY = JIM_COUNTER WHERE REC_KEY=TESTROW.REC_KEY;
	END LOOP;

COMMIT;
END;
>I am trying to get a PL/SQL script to increment a column in a table. The
>
>following script is what I have come-up with, but it runs in a loop, and
>
>is a bear to kill. I have moved the close cursor inside and outside the
>loop, but still the same results. Thanks in advance for any help.
>
>DECLARE
> JIM_COUNTER NUMBER(10) := 0;
> HOLD_REC_KEY NUMBER(10);
> CURSOR COUNT_CURSOR IS
> SELECT REC_KEY FROM TEST_COUNTER FOR UPDATE OF REC_KEY;
>BEGIN
> LOOP
> OPEN COUNT_CURSOR;
> FETCH COUNT_CURSOR INTO HOLD_REC_KEY;
> IF COUNT_CURSOR%FOUND THEN
> JIM_COUNTER := JIM_COUNTER + 1;
> UPDATE TEST_COUNTER SET REC_KEY = JIM_COUNTER;
> ELSE
> EXIT;
> END IF;
> CLOSE COUNT_CURSOR;
> END LOOP;
>COMMIT;
>END;
>
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de

Received on Thu Mar 05 1998 - 00:00:00 CST