Re: Script runs only on one of two identical machines

r.pit_at_raadvanstate.nl (Roelof) wrote in message news:<f602866b.0209240057.bf359c8_at_posting.google.com>...
> A PL-SQL script runs on one machine. On the second machine it
> generates a error message :
> ORA-01830: date format picture ends before converting entire input
> string
> ORA-06512: at line 692
> ORA-06512: at line 708
>
> The machines are identical, login.sql is identical, same database....
>
> What can be the reason for this strange behaviour ?
>
> Roelof

NLS_DATE_FORMAT is different
run
select * from nls_session_parameters
on Wintel check hklm\software\oracle for nls_date_format string value on Unix this can an environment variable in your .profile

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Sep 24 2002 - 18:16:37 CEST