Retour
-
Titre
Error "ORA-01843: not a valid month" in work load replay. -
Description
During the work load replay, trying to insert date data into a datetime record, the error "ORA-01843: not a valid month" is received. The data being inserted is a string as 'MM/DD/YYYY' such as '11/29/2018'. -
Résolution
It seems user is trying to insert date to a table without using TO_DATE function. For example the below SQL may result in error if NLS_DATE_FORMATE is not set to MM/DD/YYYY.
INSERT INTO TEST VALUES('12/03/2018')
so the best way to insert date is use to_date function
INSERT INTO TEST VALUES(TO_DATE('12/03/2018', 'MM/DD/YYYY'))
Or if user doesn’t want to change the SQL statement then user will have to change the NLS_DATE_FORMAT parameter to MM/DD/YYYY in this case.