Using INTERVAL or TIMESTAMP With Oracle10g ODBC Driver Dumps And Oracle11g ODBC Driver Reports "Driver not capable" (Doc ID 730225.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version 10.2.0.1.0 and later
Information in this document applies to any platform.
ODBC TIMESTAMP TIMEZONE datatype


Symptoms

Oracle10g ODBC driver dumps 

stack could look like:

 

LdiDateIntertimeAdd <- LdiTimeZoneAdjust <- kpccedtm2dtm <- ttccfpg <- ttcfour <- kpufcpf <- kpufch0 <- kpufch <-
OCIStmtFetch <- bcoCacheFillBlock <- bcoCacheFetchNext <- bcoCacheFetch <- bcoSQLScroll <- bcoSQLFetch <- SQLFetch
<- SQLFetch

 

 

Oracle11g ODBC driver reports:

[Oracle][ODBC][Ora]Driver not capable
or
[Oracle][ODBC] TIMESTAMP WITH TIME ZONE is not supported

while using TIMESTAMP or INTERVAL datatype. Other datatypes failing:

 

TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms