standards 2004-08-05 - By Edgar Chupit
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
