Thank you Marco,
I resolved the problem in the meantime by setting NLS_DATE_FORMAT in Windows XP environment variables.
(and I do not have right to administer my regedit so I couldn't try you suggestion)
Regards,
Alex
When I execute the query like
select *
from ids.r_exchange_rates t
where sexc_valuation_date='12.05.2011'
I get the error message:
ORA-01843: not a valid month
The option in Tools/Preferences/Date + User Defined DD.MM.YYYY has no effect.
If I execute
ALTER SESSION SET nls_date_format =...