why aren't you doing ...
Code:
insert into TRN_NORM_30DAY
select ... from bblg.CDR_SUMMARY@prldw ...
This line-by-line stuff sucks for performance.