Hi guys,
I'm trying to create a function based index, really simple
but from some reason it dosen't work:

When i try:
SQL> alter session set nls_sort='CANADIAN FRENCH';
Session altered.
but when i try:
CREATE INDEX onair.prog_media_nls_houseno_idx2 ON
table_xxx (NLSSORT("HOUSE_NUMBER"
,'nls_sort=''CANADIAN FRENCH''') ASC
)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE ona_ID1
STORAGE (...)
ERROR at line 1:
ORA-12702: invalid NLS parameter string used in SQL function
When i checked the valid options:
SQL> select * from v$nls_valid_values
2 where parameter='SORT'
3 and value like '%CANAD%';

PARAMETER VALUE
--------------- -------------------
SORT CANADIAN FRENCH
SORT CANADIAN_M

Did any one ran into this problem? any suggestions?
thanks in advance.