Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ora -01843
Gansmeier wrote:
> Hello,
>
> Date - Time Problem
>
> can someone tell me how to avoid ora-01843
> The statements works fine against a oracle 9.2.0.1 dbms on Windows
> but it fails against oracle 10.2.0.1 dbms on suse linux.
>
> select * from nls_database_parameters;
> shows both times the same values.
>
> select * from nls_session_parameters;
> also shows both times the same values.
>
> Does someone have a tip what else might be different?
>
> Thanks in Advance for any help,
>
> Markus Gansmeier
We need to see DDL and DML. I had this error with a query on a view. The view contained a TIMESTAMP column that was converted using TO_CHAR and the query used a TIMESTAMP to filter on this column. Changing the view to CAST( x AS DATE) resolved the issue here. YMMV.
robert Received on Fri Dec 09 2005 - 06:14:52 CST