4 Replies Latest reply: Jul 26, 2011 8:05 AM by Jane Jackman RSS

    Oracle timestamp (6) gives SQL_UNKNOWN_TYPE (0) as DATA_TYPE

    Jane Jackman

      Hi All,

       

      I have a client who is connecting to both tables and views in Oracle 11 via the 32 bit ODBC driver MSORCL32.dll v 6.01.7601.17514 from qv 10. He is not able to acquire data from Timestamp (6) datatype columns, they are marked as SQL_UNKNOWN_TYPE (0) as DATA_TYPE in the table information box. The TYPE_NAME is TIMESTAMP (6). Any ideas please? Do you think I should pass this back formally to support?

       

      I ahve asked him to try this in the mean time:-

       

      Load *;

      SQL SELECT TO_CHAR(DTCOL,'DD-MON-YYYY HH24:MI:SSxFF')

      FROM TABLENAME;


      Cheers,

       

      Jane