Skip to Main Content

Oracle Database Discussions

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!

Oracle sql developer Doc_date GDK-05043: not a valid month

SANPATJul 9 2020 — edited Jul 10 2020

Dear Friends

I am trying to import data , but receiving the error message as Doc_Date GDK-05043: not a valid month. Even in the Sql developer tried to change the NLS in tools -> preference -> Database  -> NLS and selected the date as DD-MON-YYYY, even changed in sql as ALTER session set NLS_DATE_FORMAT='DD/MM/YYYY';

Still getting the error message,

kindly advance how to Import the excel data where date is available in Sql Developer.

Sanjay

This post has been answered by L. Fernigrini on Jul 9 2020
Jump to Answer
Comments
Post Details
Added on Jul 9 2020
3 comments
3,805 views