DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: force to use certain rollback

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    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;

  2. #2
    Join Date
    Jan 2002
    Posts
    59
    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
  •  


Click Here to Expand Forum to Full Width