This is a migrated thread and some comments may be shown as answers.

Case Insensitive - Oracle

0 Answers 64 Views
Data Access Free Edition
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Ziti
Top achievements
Rank 1
Ziti asked on 24 Aug 2016, 09:25 AM

Hi,

We are currently using Telerik Data Access to connect to a Oracle database and I am trying to get case insensitive queries to work.

If I run the following query directly on the database, I get the results I want:

ALTER SESSION SET NLS_SORT=BINARY_CI;
ALTER SESSION SET NLS_COMP=LINGUISTIC;
SELECT * FROM ... WHERE FIELD = 'CaseDoesntMatter'

I tried add the above alter statements to the backend configuration using the following:

backendConfiguration.ConnectionPool.InitSQL.Add("ALTER SESSION SET NLS_SORT=BINARY_CI");

backendConfiguration.ConnectionPool.InitSQL.Add("ALTER SESSION SET NLS_COMP=LINGUISTIC");

However, running the above results in an exception:

"ORA-01013: user requested cancel of current operation"

If I run either statement individually I don't get the exception, however the queries performed are still not case insensitive.

Any assistance with this issue would be appreciated.


Tags
Data Access Free Edition
Asked by
Ziti
Top achievements
Rank 1
Share this question
or