[cx-oracle-users] Re: cx_Oracle: Supported Oracle Types?

[copal <co...@dr...>]

hahaha...i'm such a dummy sometimes.  too much staring into vim.  found the
rest of the types...now i just need to figure out why this is failing...

sorry for my own confusion.

On 1/17/06, copal <co...@dr...> wrote:
>
> i have compiled cx_Oracle-4.1.2 on solaris for Oracle 8.1.6, but am
> getting the following error when performing a simple query:
>
> --- snip ---
>
> cx_Oracle.NotSupportedError: Variable_TypeByOracleDataType: unhandled dat=
a
> type 187
>
> --- snip ---
>
> a quick grep through $ORACLE_HOME/rdbms/demo/ocidfn.h shows type 187 as
> SQLT_TIMESTAMP, but  looking though the StringVar.c file shows only 4
> Oracle types listed: SQLT_CHR, SQLT_AFC, SQLT_BIN.
>
> have i missed something incredibly mundane, or does this module (the only
> python one listed on oracle's site) really not support datatypes as
> rudimentary as timestamps?
>
> incredibly confused - any help would be greatly appreciated.
>