cursor c1 is select * from temp1 where id between 1 to 20
cursor c2 is select * from temp1 where id between 21 to 40

create or replace procedure datafix.xxemp1 ( p_deptno in number,p_sal out number,p_ename out varchar2 ) 
is
m number;
cursor c is
select sal,ename 
from emp2
where deptno=p_deptno;

begin
m:=0;
open c;
loop
fetch c into p_sal,p_ename;   
     
exit when c%notfound;

if c%rowcount>m then
dbms_output.put_line('cur count is :  ' ||c%rowcount);
dbms_output.put_line(p_sal||'  '||p_ename);
m:=m+1;
if mod(m,2)=0 then
close c;
dbms_output.put_line('cur closed');
open c;
dbms_output.put_line('cur opened');
end if;
end if;
end loop;
close c;
end xxemp1;

CURSOR cur_archive_rec is                

select id from table_A
where id between 1000 and 15000 
and id>last_id
order by id
for update NOWAIT;

PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:

   begin case declare else elsif end exit for goto if loop mod
   null pragma raise return select update while with
   <an identifier> <a double-quoted delimited-identifier>
   <a bind variable> << close current delete fetch lock insert
   open rollback savepoint set sql execute commit forall merge
   pipe

declare
last_id number;
l_cntr number;
l_actual_end_date  table_B.actual_end_date%TYPE;
l_completed_date   table_B.completed_date%TYPE; 
resource_busy EXCEPTION;
PRAGMA EXCEPTION_INIT (resource_busy, -54);
l_id number;  

CURSOR cur_archive_rec is              

select id from table_A  
where id between 293201 and 293219 
and id>last_id 
order by id
for update NOWAIT; 

begin
last_id :=0;
l_cntr :=0;                      
open cur_archive_rec ;
loop

fetch cur_archive_rec into l_id;
exit when cur_archive_rec%notfound;
select actual_end_date,completed_date into l_actual_end_date ,l_completed_date  
from table_B where w_id=l_id and id=0; 
if cur_archive_rec%rowcount>l_cntr then

update table_A
set end_date=l_actual_end_date,
close_date=l_completed_date,
seq=500,
status_code='ABC',
state='CONVERT'
where current of cur_archive_rec ;

commit;

EXCEPTION

            WHEN resource_busy
           THEN
dbms_output.put_line('Resource is buzy');
dbms_output.put_line('Records that didnot update are db_id:'||l_id);
rollback;
exit;  
     rollback;
    RAISE;

l_cntr:=l_cntr+1;
last_id:= l_id; 
if mod(l_cntr,2)=0 then  -- for every 2 records
close cur_archive_rec;

open cur_archive_rec;

l_cntr:=0;  -- this resets counter for every 2 records
end if;
end if;

end loop;
close cur_archive_rec;
end;

What you are trying to do is the most recommended method to induce "snapshot too old".

closing and re-opening cursor many a times
is totally useless.

PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:

   begin case declare exit for goto if loop mod null pragma
   raise return select update while with <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> <<
   close current delete fetch lock insert open rollback
   savepoint set sql execute commit forall merge pipe
ORA-06550: line 88, column 1:
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the follo

declare
resource_busy EXCEPTION;
PRAGMA EXCEPTION_INIT (resource_busy, -54);

--in the loop i have below exception block

EXCEPTION

            WHEN resource_busy
           THEN
dbms_output.put_line('Resource is buzy');
dbms_output.put_line('Records that didnot update are db_id:'||l_db_id);
rollback;
exit;  --when resource is buzy ,it will show msg and exit-when others then
when others then      
         rollback;
                RAISE;

Please go and read the posting guidelines as to how to post 'code' 

If you want help from these people, you really, REALLY need to start paying attention to what they are asking.

Did you bother to read any of the previous replies?

Connected to:
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

SQL> create table lock_test as select rownum a, rownum b from dual connect by level < 100;

Table created.

SQL> update lock_test set b = 10 where a = 5;

1 row updated.

SQL> 

SQL> set serveroutput on;

SQL> DECLARE
  2  
  3    CURSOR c1 IS
  4    SELECT a, b
  5    FROM lock_test
  6    WHERE a BETWEEN 1 and 20
  7    FOR UPDATE OF b NOWAIT;
  8    
  9    r1 c1%ROWTYPE;
 10    
 11  BEGIN
 12  
 13    dbms_output.put_line('start');
 14    OPEN c1;
 15    dbms_output.put_line('opened cursor');
 16    LOOP
 17      FETCH c1 INTO r1;
 18      dbms_output.put_line('fetched');
 19      EXIT WHEN c1%NOTFOUND;
 20      
 21    END LOOP;
 22    CLOSE c1;
 23    dbms_output.put_line('end');
 24    
 25  END;
 26  /
start
DECLARE
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-06512: at line 4
ORA-06512: at line 14

SQL> rollback;

Rollback complete.

SQL> set serveroutput on
SQL> DECLARE
  2  
  3    CURSOR c1 IS
  4    SELECT a, b
  5    FROM lock_test
  6    WHERE a BETWEEN 1 and 20
  7    FOR UPDATE OF b NOWAIT;
  8    
  9    r1 c1%ROWTYPE;
 10    
 11  BEGIN
 12  
 13    dbms_output.put_line('start');
 14    OPEN c1;
 15    dbms_output.put_line('opened cursor');
 16    LOOP
 17      FETCH c1 INTO r1;
 18      dbms_output.put_line('fetched');
 19      EXIT WHEN c1%NOTFOUND;
 20      
 21      UPDATE lock_test
 22      SET b = r1.b + 1
 23      WHERE a = r1.a;
 24      
 25      COMMIT;
 26      
 27    END LOOP;
 28    CLOSE c1;
 29    dbms_output.put_line('end');
 30    
 31  END;
 32  /
start
opened cursor
fetched
DECLARE
*
ERROR at line 1:
ORA-01002: fetch out of sequence
ORA-06512: at line 17


SQL> SELECT * from lock_test where a between 1 and 20;

         A          B
---------- ----------
         1          2
         2          2
         3          3
         4          4
         5          5
         6          6
         7          7
         8          8
         9          9
        10         10
        11         11

         A          B
---------- ----------
        12         12
        13         13
        14         14
        15         15
        16         16
        17         17
        18         18
        19         19
        20         20

20 rows selected.

SQL> 

declare              
last_id         number;
l_end_date      date;
l_comp_date     date; 
l_db_id         number;
l_id            number;
count_recs      number;
total_recs_read number;

cursor cursor_1 is
select id from table_A 
where id between 29320 and 135912
and id>last_id 
order by id;

begin

last_id:=0;
count_recs:=0;
total_recs_read:=0;

open cursor_1 ;

loop
fetch cursor_1 into l_db_id;

if cursor_1%found then
total_recs_read:=total_recs_read+1;
end if;

exit when cursor_1%notfound;

select end_date,comp_date into l_end_date ,l_comp_date  
from table_B
where w_id=l_db_id and d_id=0; 

/*below code updates table and has exception block*/

declare
resource_busy EXCEPTION;
PRAGMA EXCEPTION_INIT (resource_busy, -54);

cursor cursor_2 is
select 1 from table_A 
where id=l_db_id
for update nowait;

begin
open cursor_2;
loop
fetch cursor_2 into l_id;
exit when cursor_2%notfound;

update  table_A    
set end_date=l_end_date,
w_close_date=l_comp_date,
w_seq=100,
w_status_code='XYZ',
w_state='ABC' ,
modify_date=sysdate,
modify_user_id='USR'
where current of cursor_2  ;
 
commit;            --commits for every record
  exit;
  
end loop;
close cursor_2;
  exception
when resource_busy then
rollback;
raise;
dbms_output.put_line('id which didnot get updated is :'||l_db_id);
when others then 
     rollback;
      raise;
      dbms_output.put_line('id which didnot get updated is :'||l_db_id);

   end;

/*update code finished here*/

last_id:=l_db_id;

if cursor_1%rowcount>20 then  --this closes and re-opens cursor for every 20 records
close cursor_1; 
open cursor_1;  
end if;    

count_recs:=count_recs+1;
end loop;        

if cursor_1%isopen then
close cursor_1;
end if;
commit;

dbms_output.put_line('total records read is: '||total_recs_read);   
dbms_output.put_line('total records updated is: '||count_recs);

exception
when others then
rollback;
raise;
dbms_output.put_line('the db_id which didnot get updated is: '||l_db_id);

end;