Variables Throug DB Link doesnt work

[HolgerS]

Hi,
we are using DOA vs a Oracle 8.1.7 DB which has a Database Link (@Vfo) to a 7.3.4 DB

We are running into a problem where a Query with more than 1 Variable doesnt work anymore
(no resultset),

Example :

SELECT * FROM USER_TAB_COLUMNS@vfo WHERE table_name='DGLAND'
AND column_name='DG_LND_BEZ';

Returns 1 Record, OK

SELECT * FROM USER_TAB_COLUMNS@vfo WHERE table_name=:TABLENAME
AND column_name='DG_LND_BEZ'; works also

SELECT * FROM USER_TAB_COLUMNS@vfo
WHERE table_name='DGLAND'
AND column_name=:COLUMNNAME; works fine

SELECT * FROM USER_TAB_COLUMNS@v3fo WHERE table_name=:TABLENAME
AND table_name=:TABLENAME; -- silly, but works , still one variable

SELECT * FROM USER_TAB_COLUMNS@v3fo WHERE table_name=:TABLENAME
AND column_name=:COLUMNNAME;

-- DOESNT WORK ANYMORE , returns no rows .

Connecting to the 7.1.4 DB directly (without the link) it works also.

Problem seems to be the using of variables via a Database Link.

(SQL Plus works fine!) Is this a DOA Problem or a Client Problem ??
Any Ideas

Regards

Holger

 

[Marco Kalter]

I found several similar reports on Oracle MetaLink, so perhaps you should contact your Oracle Support representative. I assume you are also using bind variables in SQL*Plus?

------------------
Marco Kalter
Allround Automations