3 Replies Latest reply on Apr 30, 2014 1:39 PM by Uva

    getting error while updating the credit and debit field

    Uva

      Hi All,

       

      I am trying to update the credit and debit field, but getting error

      "ORA-01722: Invalid Number"

       

      My data file is this

      AE,123456,-100.60

      BE,123456,2000

      CE,123456,100.60

      DE,123456,-2000

       

      My Control file is

       

      LOAD DATA

      APPEND

      INTO TABLE DUMMY_STG

      FIELDS TERMINATED BY ','

      OPTIONALLY ENCLOSED BY '"'

      TRAILING NULLCOLS

      (

      COUNTRY FILLER,

      SEGMENT2 CHAR "TRIM(:SEGMENT2)"

      AMOUNT BOUNDFILLER,

      DEBIT CHAR "TO_NUMBER(ABS(:AMOUNT),9999999.9999999)",

      CREDIT CHAR "TO_NUMBER(ABS(:AMOUNT),9999999.9999999)"

      )

      In my table both debit and credit are of datatype number only.

       

      I could understand why I am getting error.

       

      Please help me with the same.

       

      Thanks in advance.

      Regards,

      Uva.