OCI / ODBC - Oracle Database

The values of the variables are saved in an Oracle Database.

The variable values are saved in the following table structure.

Column name

Data type

Null permitted

Characteristic

ID

NUMBER

no

IDENTITY(1,1)

Timestamp

DATE

no

 

Name

VARCHAR2

no

 

ValueType="Double"

Value

FLOAT

no

 

ValueType="Bytes"

Value

BLOB

no

 

To get the functionality of an AutoID a sequence will be create at the scheme you use with the following attributes:

name:                 For example: "AUTO_INCREMENT_myTable$"

typ:                     "ascending"

minimum:          "1"

maximum:         "1.0E27"

intervall:             "1"

cache:               "no Cache"

An AutoID is generated in the "ID" column. The value in this column is, in other words, always increased by 1. This functionality makes the sequence possible.
The "Timestamp" column stores the time at which the data record was saved.
The name of the variable is stored in the "Name" column.
The "Value" column stores the value of the variable.

E_DBColumnTypes

Oracle

PLC Control

eDBColumn_BigInt

DECIMAL(15,0)

T_LARGE_INTEGER (TcUtilities.lib)

eDBColumn_Integer

INTEGER

T_LARGE_INTEGER

eDBColumn_SmallInt

SMALLINT

T_LARGE_INTEGER

eDBColumn_TinyInt

SMALLINT

T_LARGE_INTEGER

eDBColumn_Bit

CHAR(1)

STRING

eDBColumn_Money

DECIMAL(18,4)

LREAL

eDBColumn_Float

DOUBLE PRECISION

LREAL

eDBColumn_Real

FLOAT

LREAL

eDBColumn_DateTime

DATE

DT

eDBColumn_NText

VARCHAR(254)

STRING

eDBColumn_NChar

CHAR(254)

STRING

eDBColumn_Image

BLOB

ARRAY OF BYTE

eDBColumn_NVarChar

NVARCHAR(254)

STRING

eDBColumn_Binary

BLOB

ARRAY OF BYTE

eDBColumn_VarBinary

BLOB

ARRAY OF BYTE