ORACLE and UNIDAC 6.4.16

[MICHALA]

Two errors:
1.Table with CLOB do not want to open (OCI and Direct mode)
2.Negative numbers(BINARY_DOUBLE) are displayed differently Direct:-5,66999999105947 OCI:-5,67

[MaximG]

We checked UniDAC 6.4.16 when using Oracle DB and found no problems. Please compose and send us via the e-support form ( https://www.devart.com menu "Support"\"Request Support" ) a small sample in which the problem occurs.

[MICHALA]

These two tables UniDAC not open:

Code: Select all

CREATE TABLE SYSTEM."B types"
(
  TFLOAT FLOAT,
  TNCLOB NCLOB,
  TCLOB CLOB,
  TBLOB BLOB,
  TBFILE BFILE
)


CREATE TABLE SYSTEM.BLOB_VALUES
(
  B_ID NUMBER,
  B_LONG LONG,
  B_NCLOB NCLOB,
  B_CLOB CLOB,
  B_BLOB BLOB,
  B_BFILE BFILE,
  PRIMARY KEY (
    B_ID) ENABLE VALIDATE
)

In FireDAC and ZEOS 7.2 can be opened.

Delphi 10 Berlin-Win32, Oracle XE 11.2g-Win32.

Michal

[MaximG]

The BFILE Oracle type is not supported in UniDAC

[MICHALA]

Why?
That's a pretty big limitation.

Michal

[MaximG]

UniDAC is a set of universal components for access to various DBMSs, including Oracle. To support all specific features of Oracle, for example the BFILE type, we offer ODAC - exactly these components implement a possibility of using these special features