Oracle
This section contains information on the configuration and the data type mapping of Oracle databases with ODBC.
Declaration in the TwinCAT Database Server Configurator
ODBC Oracle database | |
|---|---|
Database Type | "Odbc_Database" |
ODBC Type | Select "Oracle" from the drop-down menu. |
Driver | Select here the actually installed driver. |
Server | Enter the name or IP address of your server. |
Uid | Enter the user name here. |
Pwd | Enter the corresponding password. |
Data type mapping between DB and PLC
E_ColumnTypes | Oracle | TwinCAT PLC |
|---|---|---|
BigInt | DECIMAL(15,0) | T_ULARGE_INTEGER (TcUtilities.lib) |
Integer | INTEGER | DINT |
SmallInt | SMALLINT | INT |
TinyInt | SMALLINT | SINT |
Bit_ | CHAR(1) | BYTE |
Money | DECIMAL(18,4) | LREAL |
Float | DOUBLE PRECISION | LREAL |
Real_ | FLOAT | REAL |
DateTime | DATE | DT |
NText | VARCHAR(254) | STRING |
NChar | CHAR(254) | STRING |
Image | BLOB | ARRAY OF BYTE |
NVarChar | NVARCHAR(254) | STRING |
Binary | BLOB | ARRAY OF BYTE |
VarBinary | BLOB | ARRAY OF BYTE |
 | Data type support This database supports the data type WSTRING. (See WString support) |
| Functioning All functions of the TwinCAT Database Server can be applied to the ODBC templates. This does not apply to the "Free Connection String". |
Notice | |
Data security In flash memory devices the number of write access operations is limited. The flash memory devices can fail, with a risk of data loss.
|