Hi boris dear ....

SQL> show parameter nls

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
SQL>


Hmnnnn .....my error which is "invalid month" means that my
birthdate data contains erroneous data like for example '13012007' in which
13 is out of range for month.
I am just wondering my the function I used to filter the data in the
where clause (is_date) was not working?

Thanks....

Jenn