Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: Value not appearing in external table

    Hi

    I'm kind of confused here. Data's loading into the table fine (using the external table method). The table has like 60 columns, all of data type NUMBER apart from the DATE column.
    When I configure the loader, I set the type of header (in the excel file) to be of type VARCHAR2(500). (The value itself is e.g., 12345) just like I do for the other 58 columns in the excel file. And this is not the first time I'm doing this.
    The column in the External table (in Toad) also shows having a data type of VARCHAR2(500).

    When the excel file is processed and loaded, I can see that for that header/column, no value is present in the external table.

    The column created in the table itself is of type NUMBER but the process doesn't get this far for this to matter.

    Could really use some troubleshooting tips? Thanks.

  2. #2
    Join Date
    Aug 2008
    Posts
    464

    Logged in error

    Please ignore. Sorry and Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •