Getting ORA-01847 while loading null value to a date field in sql loader program
Hi,
Ebs Ver: 12.2.4
DB Ver: 11.2.0.3.0
I am trying to load a data file into a table using sql loader program. The table has a date field inactive_date and this can have a valid date or can be null.
Attached is the control file and data file I am using to load the data. I am able to load the data successfully when there is a value exist in the data file for the inactive_date field but it is not loading the data when the field is blank in the data file. I am getting below error message in the error log.