ORA-01843: Invalid month: TO_DATE ('12 -JUN-02 ',' DD-MON-YY ')

Question

I had a problem while pasting. Here is the problem:

INSERT INTO SALES_ORDER_A4 (ORDERNO , CLIENTNO , ORDERDATE , DELYADDR , SALESMANNO , DELYTYPE , BILLYN , DELYDATE, ORDERSTATUS) SELECT 'O19008' , 'C00005' , to_date('24-MAY-02','DD-MON-YY'), 'Delhi' , 'S00004' , 'F' , 'N' , to_date('26-MAY-02','DD-MON-YY') , 'In Process' FROM DUAL UNION ALL SELECT 'O19001' , 'C00001' , to_date('12-JUN-02','DD-MON-YY') , 'Delhi' , 'S00001' , 'F' , 'N' , to_date('20-JUN-02','DD-MON-YY') , 'In Process' FROM DUAL UNION ALL SELECT 'O19002' , 'C00002' , to_date('25-JUN-02','DD-MON-YY'), 'Delhi' , 'S00002' , 'P' , 'N' , to_date('27-JUL-02','DD-MON-YY') , 'Cancelled' FROM DUAL 

---

I encountered an exception to the phrase * to_date ('12 -JUN-02 ',' DD-MON-YY ') *, which:

ORA-01843: Invalid Month

My instructor cannot find the problem, what is the problem?

Answer 1

This is mainly because NLS_DATE_LANGUAGE is not set correctly.

First check the value for:

 select * from v$nls_parameters where parameter like '%DATE%' 

If the value of NLS_DATE_LANGUAGE not equal to American , then change it to:

 alter session set nls_date_language='American'; 

And try again.