problem with a database link

Hello

I am using Oracle 7.3 on Windows NT.

I have a big problem using a database link in my application :

The join doesn't work (return no row) if i have no criteria concerning the linked table after the WHERE.

For example :

In the first database
I have a table called ADR with 3 columns KEY_MED , KEY_ADR and PHONE

KEY_MED,KEY_ADR,PHONE
'AS101','ADR1','0153200043'
and a link to another database.
the link's name is lien_bm

In the second database
I have a table called MED with 2 columns KEY_MED and NAME

KEY_MED,NAME
'AS101','CAILLAUD'
but when I try to join the 2 tables together, I have some problems.

when the query is

select MED.NAME, ADR.PHONE from ADR, MED_at_lien_bm where ADR.KEY_MED=MED.KEY_MED I have no result.
In the same way,

select MED.NAME, ADR.PHONE from ADR, MED_at_lien_bm where ADR.KEY_MED=MED.KEY_MED and ADR_PHONE ='0153200043'

returns no row,

but when the query is

select MED.NAME, ADR.PHONE from ADR, MED_at_lien_bm where ADR.KEY_MED=MED.KEY_MED and MED.NAME like 'CAILLAUD%'

it finds

'0153200043','CAILLAUD'
I've tried with a database link, with a public synonym of the database link, with a view of the table MED and there's still the same problem.

If somebody has an idea, he's welcome.

Thanks Received on Wed Jun 10 1998 - 09:36:53 CDT