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() );
Code: Select all
Qry.Options.FieldsAsString := True;
Qry.SQL.Text := 'SELECT * FROM TTT@querypie_xe_hr_link';
Qry.Open
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() );
Code: Select all
Qry.Options.FieldsAsString := True;
Qry.SQL.Text := 'SELECT * FROM MMM';
Qry.Open
Thanks,
Best regards,
Benjamin Yang