HS_NLS_DATE_LANGUAGE

Default value:	Value determined by HS_LANGUAGE parameter
Range of values:	Any valid NLS_LANGUAGE value (up to 255 characters)

Specifies the language used in character date values coming from the non-Oracle system. Date formats can be language independent. For example, if the format is 'dd/mm/yyyy', all three components of the character date are numbers. In the format 'dd-mon-yyyy', however, the month component is the name abbreviated to three characters. This abbreviation is very much language dependent. For example, the abbreviation for the month April is "apr", which in French is "avr" (Avril).

Heterogeneous Services assumes that character date values fetched from the non-Oracle system are in this format. Also, Heterogeneous Services sends character date bind values in this format to the non-Oracle system.