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

Thread: proceduer returning error "ORA-01406: fetched column value was truncated"

Threaded View

  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Angry proceduer returning error "ORA-01406: fetched column value was truncated"

    Dear:

    I am trying to execute the following procedure and but it is returing exception "ORA-01406: fetched column value was truncated" at the first cursor fetch:
    --------------------------------------------------------------
    CREATE OR REPLACE procedure process_payment is

    --variables
    var_msisdn varchar2 (15);
    var_amount number;
    err_code varchar2 (2000);

    --cursor, Error is coming from here
    cursor cur_EVT is
    select msisdn,amount
    from cust_pay@tovoucher
    where status=0;

    Begin
    FOR w_cur_EVT in cur_EVT LOOP
    var_msisdn := w_cur_EVT.msisdn;
    var_amount := w_cur_EVT.amount;
    --update e-voucher
    update cust_pay@tovoucher
    set status=9
    where msisdn=var_msisdn
    and amount=var_amount
    and status=0;

    commit;
    END LOOP;

    insert into process_log (TIME_STAMP,STATUS)
    (select sysdate,'successful' from dual);

    commit;

    EXCEPTION
    WHEN OTHERS THEN
    rollback;
    err_code := SQLERRM;
    insert into process_log (TIME_STAMP,STATUS,NOTE)
    (select sysdate,'failed',err_code from dual);

    commit;
    end;
    /

    --------------------------------------------------------------

    I am accessing a remote DB through a dblink as shown in the script. I can not figure out the reason. Please help.

    -Taufique.
    Last edited by taufique; 02-16-2007 at 01:50 AM.

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