Skip to Main Content

SQL & PL/SQL

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!

ORA-12702

514692Jul 2 2007 — edited Jul 2 2007
hi, i execute this query without a prob in a 10g db

select *
from test
ORDER BY NLSSORT(titulo , 'NLS_SORT=BINARY_AI' )

but when i try to execute it on a 9i db it give the error:

ORA-12702: invalid NLS parameter string used in SQL function

ive been searching the forum for an answer but cant find any that makes sense, can someone help me pls

ty in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2007
Added on Jul 2 2007
3 comments
895 views