Re: Oracle SQL plus error

In article <8vv240$nb8$1_at_nnrp1.deja.com>,   yuen_121_at_my-deja.com wrote:
> Dear all,
> If I execute the following SQL statment in the Oracle SQL *PLUS :
> insert into testing values (TO_DATE('12-JAN-1999','DD-MON-YYYY'))
>
> the following error occur:
> insert into testing values (TO_DATE('12-JAN-1999','DD-MON-YYYY'))
> *
> ERROR in row 1:
> ORA-01843: not a valid month
>
> But it worked fine in Oracle SQL *PLUS worksheet. Is there any
> environment variable need to set?

Check the NLS_LANG environment var. You may also call TO_DATE with a specified nls_lang instead:
insert into testing values (TO_DATE('12-ENE-1999','DD-MON-YYYY', 'NLS_DATE_LANGUAGE=SPANISH'))
Or, third, you may change this setting for the current session: alter session set nls_language=german;

HTH

--
-=[ Sancho ]=-


Sent via Deja.com http://www.deja.com/
Before you buy.