Skip to Content (Press Enter)
UserImage.jpg
Tobi McFarland
94Views
5Comments
Solved
How to set NLS_COMP and NLS_SORT in the UI
Question
Reactive
OutSystems 11

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
3
0
07 Jun 2021
Copy Link
2025-10-16 19-55-50
Thomas Giancola
Solution

Also, you may need to add a suggestion 

/* %LogicalDatabase%=GetLogicalDatabase({TABLENAME}) */
See solution in context
4
0
07 Jun 2021
Copy Link
2025-10-16 19-55-50
Thomas Giancola
2024-10-25 08-47-19
Eduardo Pires

Hello.

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



5
0
07 Jun 2021
Copy Link
2025-10-16 19-55-50
Thomas Giancola
Solution

Also, you may need to add a suggestion 

/* %LogicalDatabase%=GetLogicalDatabase({TABLENAME}) */
4
0
07 Jun 2021
Copy Link
2025-10-16 19-55-50
Thomas Giancola
UserImage.jpg
Tobi McFarland

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
1
0
07 Jun 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.