| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Exception raised in a loop
Hi , Is it possible to raised a exception inside a loop in oracle 9i??
PROCEDURE somprocedure (resultado OUT generic_cursor) IS
tmp INTEGER;
tmp_2 INTEGER;
stringsql VARCHAR (3000);
CURSOR movimientosprimero
IS
SELECT DISTINCT *
FROM sometable
WHERE tipo_mov <> 'B';
BEGIN
FOR regfichero IN movimientosprimero
LOOP
.................
.................
COMMIT;
exception
when others then
return;
END LOOP;
Received on Wed Apr 18 2007 - 06:44:12 CDT
![]() |
![]() |