strange behaviour (oracle 8.1.7.4.0)

I have a table composed by varchar2, number and date columns. If I alter the current session like this

ALTER SESSION SET NLS_COMP=ANSI;
ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER; and execute a select statement like

select * from table where varchar2_10_field = 'a string value'

the result simply ignore the where clause and I get all the records. The same exception doesn't occurr in oracle9i

Is there anyone that experienced souch a bahaviour?

Thanks
Fabio Received on Mon Jul 11 2005 - 05:02:50 CDT