Exception when upgrading from Delphi 10 Seattle dbExpress 6.8.12 (28-Apr-16) to Delphi 13.3.3 Rio dbExpress 7.2.1 09-Jun

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
PioLek
Posts: 3
Joined: Sun 16 Feb 2020 15:37

Exception when upgrading from Delphi 10 Seattle dbExpress 6.8.12 (28-Apr-16) to Delphi 13.3.3 Rio dbExpress 7.2.1 09-Jun

Post by PioLek » Mon 02 Nov 2020 19:07

On a new development computer, we upgraded project from Delphi 10 Seattle dbExpress 6.8.12 (28-Apr-16) to Delphi 13.3.3 Rio dbExpress 7.2.1 09-Jun-20

The code works fine in the original project with Delphi 10 on the old devlopment Computer.

(FYI...We also used SQLServer and the code also works fine with the dbExpress SQLServer driver with a SQLServer Database on our old and new development computers.)

The SQLQuery looks like:
SQLQuery.SQL.Text:='"Line","Category","Description","Image Type","Image File Name","Image"' FROM TABLEIMAGE';

In Delphi we get an exception with the following line of code:
ClientDataSet.Open;

Project raised an exception class EAssertionFailed with message 'Unknown data type (0) (D:ProjectsClone2\Delphi\Dbx\Common\Source\dbexp.pas, line 2383)

Oracle DESC of TABLEIMAGE
Name Null? Type
----------------------------------------- -------- ----------------------------
Line NOT NULL VARCHAR2(10)
Image File Name VARCHAR2(100)
Category VARCHAR2(30)
Description VARCHAR2(50)
Image Type VARCHAR2(40)
Image LONG RAW

Post Reply