Re: to_char(sysdate) gives an nls error

Znake wrote:
> 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

Sometimes.... when? And what error (digits and codes, pls?) Client and server versions are?!?

-- 

Regards,
Frank van Bortel