RE: Languages

This seems to be a NLS environment issue. Try setting nls_date_format and/or nls_language.

hth

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mário Gamito Sent: Thursday, October 09, 2008 9:23 AM To: oracle-l_at_freelists.org
Subject: Languages

Hi,

I've installed Oracle 10g in Windows, and it installed both English and Portuguese languages.
All the software is English writen. The feedback, errors and warnings are in portuguese. It's not to my liking, but I can live with that.

The problem is in the SQL itself.

For example, if I try to get the day after FRIday, I get an error with this statement:

SELECT NEXT_DAY(SYSDATE, 'FRI') FROM dual;

because, FRI(day) is for English. The statement runs smoothly if I change "FRI" for "SEX" which are the first three letters for Friday in portuguse (sexta).

Does anyone knows how can I set the whole system to be in English ?

Any help would be appreciated.

Warm Regards,
Mário Gamito
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 09 2008 - 07:49:58 CDT