Connecting to ORACLE: "ALTER SESSION" commands require ODBC DSN or OLE DB Provider

When connecting to ORACLE Database, "ALTER SESSION" command can be used to change settings of current settings.

However, when using Qlik supplied ODBC Connector Package, "ALTER SESSION" command executed by SQL statement will cause "QVX_UNEXPECTED_END_OF_DATA" error as shown in this example:
 

LIB CONNECT TO 'Oracle Connection by ODBC Package'
Connected.
NLS_SESSION_PARAMETERS_Before:
Load PARAMETER as PARAMETER_BEFORE, VALUE as VALUE_BEFORE
SQL SELECT * FROM NLS_SESSION_PARAMETERS
    2 fields found: PARAMETER_BEFORE, VALUE_BEFORE,
      17 lines fetched
SQL ALTER SESSION SET NLS_LANGUAGE=German
    1 fields found: *,
      Error: QVX_UNEXPECTED_END_OF_DATA: Unable to get column information for the fields that are used in the query:
      Object reference not set to an instance of an object.
Execution Failed
Execution finished.

How to resolve it?

Qlik ODBC Connector Package has such a limitation when it comes to executing SQL with no data return, such as ALTER SESSION commands.

Use ORACLE supplied ODBC driver(via DSN) instead.

 

LIB CONNECT TO 'Oracle Connection by ODBC DSN'
NLS_SESSION_PARAMETERS_Before:
Load PARAMETER as PARAMETER_BEFORE, VALUE as VALUE_BEFORE
SQL SELECT * FROM NLS_SESSION_PARAMETERS
    2 fields found: PARAMETER_BEFORE, VALUE_BEFORE,
      17 lines fetched
SQL ALTER SESSION SET NLS_LANGUAGE=German
NLS_SESSION_PARAMETER_After:
Load PARAMETER as PARAMTER_After, VALUE_After
SQL SELECT * FRO NLS_SESSION_PARAMETERS
    2 fields found: PARAMETER_After, VALUE_After,
      17 lines fetched
DisConnect
Creating search index
Search inded creation completed successfully
Execution finished.

Or use Oracle supplied OLE DB Provider instead.

 

LIB CONNECT TO 'Oracle Connection by OLE DB'
NLS_SESSION_PARAMETERS_Before:
Load PARAMETER as PARAMETER_BEFORE, VALUE as VALUE_BEFORE
SQL SELECT * FROM NLS_SESSION_PARAMETERS
    2 fields found: PARAMETER_BEFORE, VALUE_BEFORE,
      17 lines fetched
SQL ALTER SESSION SET NLS_LANGUAGE=German
NLS_SESSION_PARAMETER_After:
Load PARAMETER as PARAMTER_After, VALUE_After
SQL SELECT * FRO NLS_SESSION_PARAMETERS
    2 fields found: PARAMETER_After, VALUE_After,
     17 lines fetched
DisConnect
Creating search index
Indexing field: VALUE_BEFORE
Indeding field: VALUE_After
Search inded creation completed successfully
Execution finished.