Important Settings for Oracle Database

System Variable

When Oracle Database is used a Windows System Environment variable named AMT_ORACLE_WRAPPER needs to be added. This variable should point to the ORACLE Wrapper dll using the fully qualified path.

The ORACLE wrapper is intended to be used along side ODP.NET Core (ODAC).

Note: the ORACLE Wrapper should be installed locally and have a System Variable set on all the machines running an AMT application, controller or service. And also on machines which will run the AMT Developer Studio, even if they run the developer remotely.

For example:

Where the 'Variable value:' is pointing to the following file:

<AMT Installation Directory>\AmtTools\OracleWrapper\Asysco.Amt.AmtOracleWrapper.dll

From AMT 86 onwards the .NET Framework versions of the ORACLE wrapper are no longer supported, the previously used AMT_ORACLE_WRAPPERCORE variable is also obsolete from that AMT version.

Recommended database collation and characterset

NLS_CHARACTERSET      : WE8MSWIN1252
NLS_NCHAR_CHARACTERSET : AL16UTF16
NLS_SORT               : BINARY
NLS_COMP               : BINARY

SQL statement to check the database character sets:
SELECT * FROM NLS_DATABASE_PARAMETERS;