When attempting to import rows to an Oracle table from an xml file which was exported from another Oracle table (with same table description), the following error occurs:
"Value does not match the type of column
Value 'm/d/yyyy 12:00:00AM' cannot be converted to type NUMBER of column column_name"
The data in the source table column contained a number , not a date
WORKAROUND
Use another format to export the data i.e. .csv or Excel or 'Insert statements'
STATUS
Waiting for fix in a future release of Toad for Data Analysts
