How to set NLS_COMP and NLS_SORT in the UI

Good Afternoon-


I'm using OutSystems with an Oracle 19c database.  The database is in production, so it would be difficult to radically alter the schema. (OutSystems version 11)

Is the a way I can do the following for the query:


alter session set NLS_COMP=LINGUISTIC;


alter session set NLS_SORT=BINARY_CI;


I tried doing it with the SQL component but received an "Incorrect Syntax near session" error.  


Is it possible to use the oracle "ALTER SESSION" command in the 

outsystemsaltersession.PNG

Solution

Also, you may need to add a suggestion 

/* %LogicalDatabase%=GetLogicalDatabase({TABLENAME}) */

Hello.

Have you tried to run the alter session on a separate query before the select query like this?



Solution

Also, you may need to add a suggestion 

/* %LogicalDatabase%=GetLogicalDatabase({TABLENAME}) */

For Oracle peeps coming after us-break use different alter session statement (if there are multiple) into it's own and add the line Tom posted like:

/* %LogicalDatabase%=GetLogicalDatabase({TABLE_NAME}) */
Alter session 
Set NLS_SORT=BINARY_CI
finalaltersession.PNG

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.