troubleshooting Question

ORA-00932 - Oracle Linked Table Error because of 'INTEVAL DAY TO SECOND' data type

Avatar of a260148
a260148Flag for United States of America asked on
SQL
9 Comments1 Solution494 ViewsLast Modified:
I odbc in a table from Oracle into an Access file. I can open the linked table, but there is a field that is an Oracle type of 'INTERVAL DAY TO SECOND'. Until I touch this field in Access, access displays the text "OLE OBJECT' as the value. As soon as I touch the records though... Access errors out with 'ORA-00932: inconsistent datatypes: expected %s got %s (#932). Same results in a Pasthrough query. I realize it is probably because the Access doesn't know how or what to convert this Oracle Data type to.. but I need to be able to use the linked table in access. Any help is much appreciated. Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros