Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: standards
Juris,
JVal> begin JVal> insert into number_table values ('a'); JVal> exception when others then JVal> insert into app_error_log values (v_sqlcode, v_sqlerrm); JVal> commit; JVal> end;
I think that this is bad style either. Because you are not only committing error info, but also all the work that was done in the loop. It would be much nicer to use procedure with pragma autonomous_transaction and log errors from another, separate transaction.
--
Best regards,
Edgar
![]() |
![]() |