1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Other Development Tools' started by upmuthukumar, Jan 22, 2013.

  1. upmuthukumar

    upmuthukumar Active Member

    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    85
    Hello all,

    I am getting below error while running sqlloder.

    Record 1: Rejected - Error on table "GL"."GL_INTERFACE", column ACCOUNTING_DATE.
    ORA-01858: a non-numeric character was found where a numeric was expected

    Record 2: Rejected - Error on table "GL"."GL_INTERFACE", column ACCOUNTING_DATE.
    ORA-01858: a non-numeric character was found where a numeric was expected

    I herewith attached the control file and data file...

    Control file

    load data
    infile 'test.txt'
    into TABLE GL_INTERFACE
    fields terminated by "," optionally enclosed by '"'
    ( STATUS, LEDGER_ID, USER_JE_SOURCE_NAME, USER_JE_CATEGORY_NAME, ACCOUNTING_DATE, CURRENCY_CODE, DATE_CREATED, CREATED_BY,
    SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5,SEGMENT6, SEGMENT7, ACTUAL_FLAG, ENTERED_DR, ENTERED_CR, GROUP_ID )


    Data file

    NEW,1,Payables,Payments,to_date('22-Dec-2012', 'DD-Mon-YYYY'),USD,to_date('23-Dec-2012', 'DD-Mon-YYYY'), 1110,03,610,000000,0000000,3111002,000000,0000000,A,1100.00,0.00,123456
    NEW,1,Payables,Payments,to_date('22-Dec-2012', 'DD-Mon-YYYY'),USD,to_date('23-Dec-2012', 'DD-Mon-YYYY'), 1110,03,610,000000,0000000,6540102,000000,0000000,A,0.00,1100.00,123456


    Please guide me what could be the issue...

    Thanks and Regards,
    Muthu
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Remove to_date and just provide '22-Dec-2012' and '23-Dec-2012' in data file and give a try. I think we are not supposed to use to_date function in data file.
     
  3. upmuthukumar

    upmuthukumar Active Member

    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    85
    Yes, Its workng...

    Thank you
     
    Bharat likes this.