u may handle in application for avoiding such errors....

commit regularly in PL/SQL that involves huge TRAN

Abhay.