Re: Deleting x records, then COMMIT

replace "ENDIF" with "END IF".

VJ.

John L Dunn wrote:
>

 <snip>
>
> DECLARE CURSOR test1 IS
> SELECT rowid
> FROM mem_month_by_period
> WHERE months <= 0;
> test_cursor_row test1%ROWTYPE;
> counter INTEGER := 0;
> BEGIN
> FOR mem_months_by_period IN test1
> LOOP
> counter := counter + 1;
> delete mem_month_by_period;
> IF counter > 100
> THEN COMMIT;
> counter := 0;
> ENDIF;

  END IF;
> END LOOP;
> END;
>

 <snip>
> *
 

-- 
Vijay Damodaran
vijayd_at_nortel.com
Work: (972) 685-8150