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?

• after all the elements are looped through? If I have a lot of data that is suppose to be updated, and i have (>= 300000) is it better to do a commit for each element?

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