The following error occurs using SQL Loader Wizard:
"ORA-01858: a non-numeric character was found where a numeric was expected"
The input text file has date fields and the Oracle table as Timestamp fields.
Ensure the text file has the proper date format used for Timestamp data types as such:
MON-DD-YYY HH:MI:SS:SSS
Ensure the control file contains the correct Data mask for Timestamp data types in the list of table column names as such:
COLUMNNAME_DT TIMESTAMP "Mon dd yyyy HH24:MI:SS.FF"
Data types and date masks can also be set in Toad's SQL Loader Wizard.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center