long field in db link

[ysyang99]

Hi

I use Delphi 2009 and ODAC 9.2.7

I found problem but OCI Login is valid. it is happen only Diret mode

After make db link and query table

Code: Select all

SELECT * FROM COUNTRIES2@DBLinkHR2

it is valid.

COUNTRIES2 DDL is

Code: Select all

CREATE TABLE HR.COUNTRIES2 (
  COUNTRY_ID      CHAR(2 BYTE)          NOT NULL, 
  COUNTRY_NAME    VARCHAR2(40 BYTE)         NULL, 
  REGION_ID       NUMBER                    NULL, 
  COMMENT2        LONG                      NULL
)

Code: Select all

SELECT COMMENT2 FROM COUNTRIES2@DBLinkHR2

it is invalid.

Unknown error 1

What's the problem?

[AlexP]

Hello,

We cannot reproduce the problem. Please provide the script for creating DBLink, and specify the versions of both Oracle servers.

[ysyang99]

Oracle version is
Oracle Version : 10.2.0.3.0
DB Link Oracle Version : 10.2.0.3.0

[AlexP]

Please provide the script for creating DBLink

[ysyang99]

Code: Select all

CREATE DATABASE LINK DBLINKHR2
CONNECT TO HR
IDENTIFIED BY "HR"
USING 'SQLGate_UTF8';

[AlexP]

We cannot reproduce the problem on our servers. If you can give us access to your server, we will try to reproduce the problem directly on your server. Unfortunately, we cannot resolve the issue an issue without reproducing it.