4 Replies Latest reply: Mar 5, 2013 11:56 PM by 994778 RSS

    ERR: a non-numeric character was found where a numeric was expected

    955015
      Hi,

      I am trying to load data from csv to oracle while loading it is giving me a error like

      ORA-01858: a non-numeric character was found where a numeric was expected

      1. I have 3 date columns in source, I converted them into date
      e.g.
      to_date(DAT.CALENDAR_DATE,'MM/DD/YYYY')

      2. some of them are numeric which I converted them into number
      e.g.
      to_number(DAT.WEEK)

      Still it is giving the same error.

      Please share your valuable suggestions..



      Thanks.