You should change your code so that it runs faster, and does not process accross commits. Using pl/sql collections should help.