What to do if you get an "incorrect bookmark ordinal" error when using SQL Server with our Oracle ODBC Driver

If you use a four part query in SQL Server such as:


you may, depending on the indexes defined on the target table, get the following OLE DB provider error:

The OLE DB provider "MSDASQL" for linked server "ORACLEWP"
returned a "NON-CLUSTERED and NOT INTEGRATED" index
"SYS_C0010082" with the incorrect bookmark ordinal 0.

To work around this error, go into the properties for the MSDASQL provider and un-check the "Index as access path" option. Then re-run your query.