Hello everyone,

Thank you Pythian & Steven for the event. It was a very interesting discussion even for me who rarely writes in PL/SQL. It looks like I need to get more practice as I have got the worst results in the quiz ;)

Some topic during the discussion has attracted my interest. And I made a small research.
According to the results it looks like I face a bug in 11G version. 11G seams to be ignoring NLS_LANG settings in PL/SQL.

I tested it using 10.2.0.4 Windows Client and 11.1.0.7 DB on Linux.



The sort description is as following:
1. I use LATVIAN NLS_SORT as I had previous experience working in that NLS area
2. The Associative Array is sorted using character string
3. I inserted the same date to a table in order to check that would be the result of sorting the same data in SQL
4. Server output shows incorrect sorting national "n" should be before "o"
5. run the SQL sort to reflect the same data sorted using LATVIAN NLS
6. The correct result reflected

Once again THANK YOU!
Beginer in PL/SQL
Yury