Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL - writing better code

PL/SQL - writing better code

From: RanLi <gladpike_at_hotmail.com>
Date: 19 Oct 2006 05:35:31 -0700
Message-ID: <1161261331.792639.255190@f16g2000cwb.googlegroups.com>


hi
need to run some thoughts about coding in pl/sql by someone, and you guys seem to be the closest. :)

PROBLEM/SITUATION:
i have a procedure that loops through a set of keys. I update a column for each key.
LOOP ----
BEGIN

       <update statement>
        COMMIT;

         EXCEPTION
            WHEN OTHERS
            THEN
               ROLLBACK;

END;
END LOOP; when is it more wise to run a commit on the data?
- after each update?

thanks.-
ranli..... :) Received on Thu Oct 19 2006 - 07:35:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US