SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not a Valid Month Issue

user533016Sep 16 2009 — edited Sep 16 2009

Hi,

When i execute an insert statement i get ORA-01843 not a valid month error.

below is the SQL i try to execute in SQLPlus;

Insert into IKD$TA_L_FACHL_SCHRITT (FACHL_SCHRITT_ID, FACHL_SCHRITT_TEXT, VALID_FROM, VALID_TO) values (1,'LOAD_STG_TMD_ZUSATZDATEN' ,'19.08.2008','31.12.9999');

However if i execute the same in Oracle SQL developer it is working fine. Can someone please suggest what could be the reason for error in SQL PLUS ?

I suspect this to be the NLS_DATE_FORMAT setting issue, please correct if im wrong.

Thanks

This post has been answered by AndyPol on Sep 16 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2009

Added on Sep 16 2009

8 comments

338 views