Can't SELECT With Transparent Gateway

[dwtk9]

Hi All,

I've created a database link to connect my Oracle to SQL Server. The link 'abc' works perfectly fine.

I've ran a 'SELECT' statement :- "Select * from company@abc". I've got my 3 columns 'Name, Address and Phone' and their data retrieved.

However when I tupe "Select * from company@abc where name = 'MyComp' " I get an error "Ora-0094 Error name invalid identifier".

I can insert records as long as I don't use any column names. Does anyone know how I can solve this esp retrieving base on Criterias. Thanks

Derek W

[nandeep]

Try this out

SELECT * FROM table@remote_db WHERE "column_name" = value;

NOTE: "column_name" = 'value'
if the column is character data

For further information you can visit:
http://download-west.oracle.com/docs...at.htm#1004574

HTH