The Oracle company delivers Oracle, the client/server database product (in time of writing there is available the last version Oracle 11g). For development purposes Oracle products are available to be downloaded in the full verion FREE OF CHARGE on the Web pages OTN (Oracle Technology Network The license fee is paid after it is set commercially.
Work with Oracle database
- The ODBC driver from Microsoft has limited support for the TIMESTAMP data type. When using this driver for accessing the Oracle database, the date and time cannot be stored with the precision more than 1 second. The ODBC driver supplied with the Oracle database doesn't have this shortage (it stores with the precision up to split seconds).
- It is possible to write into the database by the PmTrend object if the Storage type configurator is set to Database Oracle cyclic in this object.
The database can be filled:
- by the PmTrend object, if the Storage type configurator is set in this object to Database Oracle cyclic
- by the PmAlarmEvent object, if the Storage type configurator is set to Parameters for type: Oracle database
- by the PmAdo object
- by the PmDatabase (obsolete) object via named ODBC source
For next descriptions to the Oracle, see:
PROMOTIC 8.3.24 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice