On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,585 Users
  • 2,269,760 Discussions


How can I stop Oracle Apex Data Loading Wizard from detecting source data types

Hi everyone. I need help with loading data using APEX data loading wizard.

I would like to load all the fields as varchar2. However, the data loading wizard detects some fields as numbers and throws some records in the error table.

How do I get around this? I want to minimize time I spend moving data from the error table to the main table.

Thank you in advance.