to_char(sysdate) gives an nls error

From: Znake <znake_at_lazy.dk>
Date: 23 Nov 2004 05:37:35 -0800
Message-ID: <f3012fc8.0411230537.4131e31d@posting.google.com>

I executes the following code (in sql plus in win nt):

set serveroutput on size 100000
begin
dbms_output.put_line('start:'||to_char(sysdate)); end;
/

Sometimes I get an NLS language error.

I thought that oracle always could find a nls_date_language (these settings exists in the registry).

In the registry:
oracle.nls_lang= AMERICAN_AMERICA.WE8ISO8859P1

oracle.all_homes.id0 = AMERICAN_AMERICA.WE8ISO8859P1 oracle.all_homes.id1= 'NA'

oracle.home0.nls_lang=AMERICAN_AMERICA.WE8ISO8859P1 oracle.home1.nls_lang=AMERICAN_AMERICA.WE8ISO8859P1

orahomes
...oracle1 nls_date_lang DANISH_DENMARK.WE8ISO8859P1

If looking at the oracle.all_homes.id1= 'NA' could that give the problem?

anyone have encountered the same problem? I would really appreciate a comment Received on Tue Nov 23 2004 - 07:37:35 CST