Delete no Oracle

[Anderson_Participante]

Bom David.
Rodei o comando que vc me passou.
da um erro.
como ficou.

SQL> declare
cursor crTabela
select t.rowid rid
from act110b t
where t.databkp= 1000 then
commit;
vCommit := 0;
end if;
end loop;
commit;
end;
/
select t.rowid rid
*
ERRO na linha 3:
ORA-06550: line 3, column 5:
PLS-00103: Encountered the symbol “SELECT” when expecting one of the following:
( ; is return
The symbol “is” was substituted for “SELECT” to continue.

---

se eu rodar o
select t.rowid rid
from act110b t
where t.databkp<='12/07/2007';

o select retorna.

RID

AAAr5rAAEAAA3PPAAz
AAAr5rAAEAAA3PPAA0
AAAr5rAAEAAA3PPAA1
AAAr5rAAEAAA3PPAA2
AAAr5rAAEAAA3PPAA3
AAAr5rAAEAAA3PPAA4
AAAr5rAAEAAA3PPAA5
AAAr5rAAEAAA3PPAA6
AAAr5rAAEAAA3PPAA7
AAAr5rAAEAAA3PPAA8