Re: Re[2]: standards

From: <J.Velikanovs_at_alise.lv>
Date: Thu, 5 Aug 2004 15:02:55 +0300
Message-ID: <OFEA9459DF.3C783137-ONC2256EE7.0041CED3-C2256EE7.0042F086@alise.lv>

OK OK Edgar you are right!
For demonstration purpose I have omitted this part. If I start to wrote whole code it will take to long / to boring to read. I am not developer after all ;)
Thanks for correction.
But in general it is seems you are agree with my option.

Jurijs
+371 9268222 (+2 GMT)

Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

Edgar Chupit <edgar.chupit_at_rs.lv>
Sent by: oracle-l-bounce_at_freelists.org
05.08.2004 15:01
Please respond to oracle-l

        To:     "J.Velikanovs_at_alise.lv" <oracle-l_at_freelists.org>
        cc: 
        Subject:        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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Aug 05 2004 - 07:07:00 CDT