ORA-01890: NLS error detected [message #27914] |
Tue, 11 November 2003 23:57  |
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   |
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
|
|
|
|
|
|
|
|