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 LOOPReceived on Wed Apr 18 2007 - 06:44:12 CDT
.................
.................
COMMIT; exception when others then return; END LOOP;