Nice article and with SQL Server and Oracle, it comes back into focus every couple of years. I am experiencing a problem today that is supposed to be with a date/timestamp; but, there isn't one in my query. This isn't an oddball case, it is happening regularly with a linked server from SS 2005 to Oracle10g.
The query is as follows:
SELECT [QUEUE]
FROM [EMREP]..[SYSMAN].[AQ$MGMT_LOADER_QTABLE]
The error message is as follows:
Msg 7354, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "EMREP" supplied invalid metadata for column "DELAY_TIMESTAMP". The data type is not supported.
Anybody have a clue?
(I will post in forum tomorrow)
Thanks!
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982