Oracle database
This section contains information on the configuration and the data type mapping of Oracle databases. For interfacing with an Oracle database the so-called ODP driver is used.
Compatible versions: Oracle 9i, 10g, 11g and higher
 | The TwinCAT Database Server requires the 32-bit version of the .NET ODP components. |
Declaration in the TwinCAT Database Server Configurator
Oracle database | |
|---|---|
Database Type | Select "Oracle ODP" from the drop-down menu. |
Host | Enter the IP or host name of the database. |
Service name | Enter the name of the service or the database. |
Port | Enter the communication port (optional). Default: 1521. |
Protocol | Enter the protocol (optional). Default: TCPIP. |
Scheme | Enter the database schema. |
User name | Enter the user name here. |
Password | Enter the corresponding password. |
| Windows CE support Under Windows CE this database is not supported by the TwinCAT Database Server. |
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) |
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.
|