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 



Also, you may need to add a suggestion 

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


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


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 

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