Progress
DataServer
for ORACLE Guide


National Language Support

After the DataServer connects to ORACLE, it issues the following statements to set National Language Support (NLS) parameters for the ORACLE environment:

ALTER SESSION SET NLS_DATE_FORMAT = ’YYYYMMDD’
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ’.,’ 

These settings might affect how stored procedures (including those using the send-sql-statement option) behave. Specifically, the default format that the TO_DATE function and the format of a date returned might be different. Always specify the format for the date as the second argument to the TO_DATE and TO_CHAR functions when dealing with date values.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095