Devart Forums

Posted: **Tue 18 Mar 2014 15:31**

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?

Posted: **Wed 19 Mar 2014 14:43**

Hello,

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

Posted: **Wed 19 Mar 2014 16:26**

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

Posted: **Thu 20 Mar 2014 09:36**

Please provide the script for creating DBLink

Posted: **Fri 28 Mar 2014 08:36**

Code: Select all

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

Posted: **Fri 28 Mar 2014 10:29**

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.

Devart Forums

long field in db link

long field in db link

Re: long field in db link

Re: long field in db link

Re: long field in db link

Re: long field in db link

Re: long field in db link