I did a
SQL> alter session set nls_language = SPANISH;
in the client, but still only the dates change in the output, not the data in my tables. Here are my session parameters :

SQL > select * from nls_session_parameters;

PARAMETER VALUE
------------------------------------------------------
NLS_LANGUAGE SPANISH
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SPANISH
NLS_SORT SPANISH
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY

I do not have the ORAE.MSB file, but I do not think that has anything to do with the table data conversion !!

Also, since session parameters take precendence over the environment parameters, I think setting up NLS_LANGUAGE without NLS_LANG should do the trick. Correct me if I am wrong !!

Thanks,
Shiva.


[Edited by Shiva on 06-12-2002 at 03:50 PM]