Skip to Main Content
Forums

Java Development Tools

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!

Issue :ORA-01890:NLS error detected

karmayaMay 8 2013 — edited May 8 2013
Hi all,

i am using oracle 10g, when i execute below query

Select column_1,column_2,column_3 from view_name
where trunc(c_date) >to_date('05-24-2011','MM/dd/YYYY'));

I am getting this error in Toad, but no errors in SQL developer.

Error: ORA-01890:NLS error detected

Please help me how can i solve this issue.

thanks in advance
karmaya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2013
Added on May 8 2013
#application-development-in-java, #jdeveloper-and-adf, #sql
1 comment
1,093 views