replication is working fine but its adding all the column valuesAll of which columns? And this should have failed:
select sum(trn.bal + int.int_amt) INTO v_max_crd from balance bal, interest int where accno=v_accno;Because you probably meant bal.bal instead of trn.bal. You also have no join between the tables BALANCE and INTEREST. I therefore suspect this is a homework assignment and will stop short of providing the solution. You need to get that query working in sqlplus first. You can also use TRACE in the SQLEXEC to see (in the report file) the values of the parameters being passed.