Oracle does not display message in Spanish

I successfully changed my database character set from US7ASCII to WE8ISO8859P1.

Instead of using 'select * from dual;', I think I should be able to use 'seleccione * de dual;'. But Oracle does not recognize it.

Also, it does not display messages in Spanish.

What am I missing here?

My configrations are,

Unix: ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

         NLS_LANG=spanish_spain.WE8ISO8859P1
         LANGUAGE=spanish_spain.WE8ISO8859P1
Oralce:  


         > select * from nls_session_parameters

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   SPANISH
NLS_TERRITORY                  SPAIN
NLS_CURRENCY                   Pts
NLS_ISO_CURRENCY               SPAIN
NLS_NUMERIC_CHARACTERS         ,.
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD/MM/RR
NLS_DATE_LANGUAGE              SPANISH
NLS_SORT                       SPANISH
NLS_TIME_FORMAT                HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT           DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT        DD/MM/RR HH24:MI:SSXFF TZH:TZM
NLS_DUAL_CURRENCY              ¿
NLS_COMP                       BINARY

Thank you very much.

Helen Received on Mon Jun 04 2001 - 16:32:17 CDT