Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem with changing nls_sort

714266Jul 16 2012 — edited Sep 6 2012

hi all
I am using Persian language therefore correct character sorting requires building a new NLS_SORT via Locale Builder.
I have built a Locale and every thing seems OK but when I am connecting to DB via oracle SQL developer and wants to open tables icon in tree
it gives the following error:

An error was encountered performing the requested operations:
ORA-00904: "O"."NAME" invalid identifier
*00904.00000- "%s:invalid identifier"*
**Cause:*
**Action:*
Vendor code 904

also I have the same problem with some predefined NLS_SORT like ARABIC and some other applications like dbForge data compare
what is the problem?
how could I resolve it?
thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2012

Added on Jul 16 2012

#database-key-features, #globalization-support, #problem, #sql-developer

21 comments

1,650 views