Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01890: NLS error detected
ORA-01890: NLS error detected [message #27914] Tue, 11 November 2003 23:57 Go to next message
Aescoline S
Messages: 2
Registered: November 2003
Junior Member
ORA-01890: NLS error detected
>
> We are pick up the business date from our
> application table and appending the timestamp.
>
> select to_date(to_char(bsns_dt,'DD-MON-YYYY')
> ||' '||to_char(sysdate,hh24:mi'),'DD-MON-YYYY hh24:mi') from
appln_table
>
> This select statement works fine at times
> and at times it is throwing error 01890.
> The error is not consistent.
> This does not happen in our SIT environment.
> But is happening in UAT environment. Basically two
> different machine with the same configuration.
> Please let us know how we can resolve this problem.
Re: ORA-01890: NLS error detected [message #27920 is a reply to message #27914] Wed, 12 November 2003 04:08 Go to previous messageGo to next message
ramana
Messages: 51
Registered: December 2000
Member
> select to_date(to_char(bsns_dt,'DD-MON-YYYY')
> ||' '||to_char(sysdate,hh24:mi'),'DD-MON-YYYY hh24:mi') from
appln_table

in ur query there is no single quote before
hh24:mi

> select to_date(to_char(bsns_dt,'DD-MON-YYYY')
> ||' '||to_char(sysdate,**********hh24:mi'),'DD-MON-YYYY hh24:mi') from
appln_table
Re: ORA-01890: NLS error detected [message #27944 is a reply to message #27920] Thu, 13 November 2003 03:24 Go to previous messageGo to next message
Aescoline S
Messages: 2
Registered: November 2003
Junior Member
Sorry, that was a typographical error.
When the query is run in the sql prompt
the format we get after the execution of the
query is :
DD-MON-YY
eg. '13-NOV-03'
Re: ORA-01890: NLS error detected [message #228023 is a reply to message #27914] Fri, 30 March 2007 14:12 Go to previous messageGo to next message
login100
Messages: 1
Registered: March 2007
Junior Member
It is an oracle bug. Request a patch from Oracle Support. We had the same issue on some oracle servers and that was the way we fixed it.
Re: ORA-01890: NLS error detected [message #228024 is a reply to message #27914] Fri, 30 March 2007 14:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I hope that you are proud of yourself for responding to a post from 2004.
I doubt the OP will care about your agreement. I certainly don't.
Re: ORA-01890: NLS error detected [message #269310 is a reply to message #228024] Fri, 21 September 2007 11:06 Go to previous messageGo to next message
lmcphre
Messages: 1
Registered: September 2007
Junior Member
The OP may not care but the info was indeed useful to me today.
Re: ORA-01890: NLS error detected [message #269312 is a reply to message #269310] Fri, 21 September 2007 11:09 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And it is the purpose of the forum. Cool

Regards
Michel
Previous Topic: Need Help with Query to break down a combination
Next Topic: Help with query to break down the effective dates..
Goto Forum:
  


Current Time: Tue Feb 11 12:33:27 CST 2025