• 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