Re: Exception raised in a loop

On Apr 18, 1:44 pm, valigula <valig..._at_gmail.com> wrote:
> 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;
You would need to
LOOP
begin
...
...
exception ...
end;
end loop;

COMMITTing inside a loop is one of the Seven Main Sins in Oracle.

--
Sybrand Bakker
Senior Oracle DBA