Posted by ecnaL on 11/15/05 00:35

This reply may be a bit late, but may help others....

The pass through value should not be enclosed in double-quotes; Oracle will think this is a column name (which is why you get the error message "Invalid Column Name").

You are probably using an SQL Statement like:

SELECT *
FROM OPENQUERY(LINKED_DB, 'SELECT *
FROM SCHEMA.TABLE
WHERE VALID_COLUMN = "27387M"')

Try this:

SELECT *
FROM OPENQUERY(LINKED_DB, 'SELECT *
FROM SCHEMA.TABLE
WHERE VALID_COLUMN = '''27387M''') <--- note the use of two single quotes, not double quotes.

Good luck from Melbourne AUstralia.

[Back to original message]