Devart Forums

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

I get the following generic error "ORA-03113:end-of-file on communication channel".

If I take the information from TNS names... I use
test_high = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=xxxx.oraclecloud.com))(connect_data=(service_name=yyyy.oraclecloud.com))(security=(ssl_server_cert_dn="zzzz")))

SQLConnection.Params.Values['HostName'] := 'xxxx.oraclecloud.com:1522:yyyy.oraclecloud.com';
SQLConnection.Params.Values['User_Name'] := 'myUserName';
SQLConnection.Params.Values['Password'] := 'myPassword';

I set my SQLConnection to connected=true then I get "ORA-03113:end-of-file on communication channel". I have worked through some various scenarios and appear stuck at this point.
With the Oracle Cloud database am I missing something else ? like including the security/ssl certificate? or the Oracle Cloud Wallet/Client Credentials in the SQLConnection?


On a side note I also have the dbx SQLServer product and do a direct connect to an Azure SQLServer database and all works very easily.

We are currently using Delphi 13.3 and dbexpress for Oracle 7.2.1.
We are looking to change our Oracle client server database to the the cloud.
We looking into to moving to an Oracle Cloud Autonomous Database via Direct Connect...ie Connection Name = DevArt Oracle Direct.
Is there a tutorial as to how to do this?

For example:...using TSQLConnection
DataBase=OracleTestDb
DriverName=DevartOracleDirect
HostName=OracleTestHostName