I am trying to process a table that is part of Oracle eBusiness Suite using the Microsoft driver for Oracle.
The table has four "key" fields (key fields do not strictly exist in eBusiness Suite, but when I add the Data Source tables, this particular table is interpreted as having four key fields.
One of the key fields can have a null value.
Whet I fill the table, only those rows where all of the key fields have values are read, i.e. the rows where one of the key fields is null are NOT brought into the table.
There are no selection criteria, and the query simply reads:
SELECT * FROM MTL_CROSS_REFERENCES
The data is correctly read if I use the data source trough ODBC from Access.
If I move a copy of the table to SQLServer the table also reads correctly.
Is this a bug?
Please file a bug:http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks
No comments:
Post a Comment