Devart Forums

Posted: **Tue 15 Jun 2021 15:04**

Hello,

I use Delphi 10.4, Windows 10, ODAC 11.4.3 for RAD Studio 10.4,Oracle 11g xe and Direct Mode

when reading column of table using dblink , i get a read error on certain column

create table in dblink target server(ORACLE 10g ) and insert record

Code: Select all

CREATE TABLE TTT ( RAW_DATA RAW(16));
INSERT INTO TTT VALUES ( SYS_GUID() );

The query below throws an error

Code: Select all

  Qry.Options.FieldsAsString := True;
  Qry.SQL.Text := 'SELECT * FROM TTT@querypie_xe_hr_link';
  Qry.Open

Error message is

Code: Select all

Unknown error 1.
...OraNetClasses.pas, line 2382

And if create table in server (ORACLE 11g)

Code: Select all

CREATE TABLE MMM ( RAW_DATA RAW(16));
INSERT INTO MMM VALUES ( SYS_GUID() );

The query below succeeds.

Code: Select all

  Qry.Options.FieldsAsString := True;
  Qry.SQL.Text := 'SELECT * FROM MMM';
  Qry.Open

It's probably an error related to dblink.

Thanks,

Best regards,
Benjamin Yang

Posted: **Tue 15 Jun 2021 15:42**

This issue does not occur in ODAC 10.3.8 version

Posted: **Fri 18 Jun 2021 10:56**

Thank you for the information. We will investigate the described issue and let you know the results shortly.

Devart Forums

Column read error when using DBLINK

Column read error when using DBLINK

Re: Column read error when using DBLINK

Re: Column read error when using DBLINK