-
could someone please tell me where do I put the
SET TRANSACTION USE ROLLBACK LARGE_ROLLBACK
in this procedure, PLEASE HELP, it's urgent
PROCEDURE P_UPD_QTRAN_CHK_DETAIL2 is
cursor ToBeUpdated is
select * from tbd_upd_dtl_cur_2;
v_count number(4):= 0;
begin
for rec in ToBeUpdated
loop
set transaction use rollback segment large_rollback;
v_count := v_count + 1;
if V_count = 5
then commit;
V_count:= 0;
end if;
update qtran_chk_detail a set
div_ord_grp = rec.div_ord_grp,
co_cd = rec.co_cd,
plant_no = rec.plant_no,
mtr_no = rec.mtr_no,
mtr_ctr_no = rec.mtr_ctr_no,
mmbtu_qty = rec.mmbtu_qty,
mcf_qty = rec.mcf_qty,
btu_pb = rec.btu_pb,
ctr_no = rec.ctr_no,
reverse_rbk_cd = rec.reverse_rbk_cd
--mtr_gross_amt = rec.mtr_gross_amt,
--mtr_tax_amt = rec.mtr_tax_amt
where a.chk_ctl_num = rec.chk_ctl_num
and a.bank_num = rec.bank_num
and a.bank_acct_num = rec.bank_acct_num
and a.chk_dtl_num = rec.chk_dtl_num;
end loop;
dbms_output.put_line('Finished executing p_upd_qtran_chk_detail2');
end;
-
Code:
for rec in ToBeUpdated
loop
set transaction use rollback segment large_rollback;
v_count := v_count + 1;
if V_count = 5
then commit;
V_count:= 0;
end if;
use it as
Code:
set transaction use rollback segment large_rollback;
for rec in ToBeUpdated
loop
v_count := v_count + 1;
if V_count = 5
then commit;
V_count:= 0;
set transaction use rollback segment large_rollback;
end if;
Thanx
Sanjay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|