Column read error when using DBLINK

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ysyang
Posts: 44
Joined: Tue 14 Jun 2005 09:10

Column read error when using DBLINK

Post by ysyang » 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

ysyang
Posts: 44
Joined: Tue 14 Jun 2005 09:10

Re: Column read error when using DBLINK

Post by ysyang » Tue 15 Jun 2021 15:42

This issue does not occur in ODAC 10.3.8 version

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Column read error when using DBLINK

Post by MaximG » Fri 18 Jun 2021 10:56

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

Post Reply