Setting NLS_COMP in TOraSession

MRCarver · Post by **MRCarver** » Wed 24 Jan 2007 07:10

I am using the ODAC driver with RemObjects/DataAbstract framework, and want to peform an ALTER SESSION SET NLS_COMP='LINGUISTIC'; ALTER SESSION SET NLS_SORT='BINARY_CI'. This of course is to perform a case insensitive query. From what I can glean, I want to use the TOraSession component to facilitate such a task.

Please advise as to which property, method, or event to use, and how to use it to accomplish this task.

Regards,
Monte Carver[/quote]

Challenger · Post by **Challenger** » Wed 24 Jan 2007 13:08

For this purpose you can use the ExecSQL method of the TOraSession component. For example:

Code: Select all

  OraSession.ExecSQL('ALTER SESSION SET NLS_COMP=''LINGUISTIC''', [])