lameiro / cx_oracle_on_ctypes

cx_Oracle on ctypes
22 stars 11 forks source link

vt_Object not supported #17

Open bertday opened 7 years ago

bertday commented 7 years ago

There's a line that's currently commented out:

https://github.com/lameiro/cx_oracle_on_ctypes/blob/master/cx_Oracle/variable_factory.py#L109

When I execute SQL against one of my Oracle tables, one of the column types is OBJECTVAR so I get an error: cx_Oracle.custom_exceptions.NotSupportedError: Type <cx_Oracle.variable_type.VariableType object at 0x108fcf128> (vt_Object) not found in mapping to python type

Thanks!

lameiro commented 7 years ago

Hi Robert, thanks for the bug report.

I worked today to add this missing feature, but object support is a bit complex and it will still take me a while. I will report again on Saturday.

lameiro commented 7 years ago

Hi Robert,

As expected, this turned out to be more complicated than a few hours of work. I have a few basic parts working, but I think it will still take another week or two for me to get it all in a shippable state.

I will update this ticket in a week.