Running into problem when using pd.read_sql with SQLAlchemy.

[aimanaziz1993]

Exception:
<oracledb.DbObject MDSYS.SDO_GEOMETRY at 0x1ed8385ce90> _typ

Version:
oracledb==1.4.2

The table I'm trying to read contain MDSYS.SDO_GEOMETRY column which are spatial oracle type.
However, If added the line became like this -> line 42: attr_impl = self._impl._type.attrs_by_name[name] it works. No exceptions raised.
Is there any workaround to be able to let pandas to read the table and convert them into DataFrame?

Thanks guys for the help!

[cjbj]

• please don't include screenshots: not everyone can read them, and we can't cut/paste to test or reply
• please show some code and the SQL to create your tables etc
• should you ask this on the pandas or sqlalchemy projects?

[anthony-tuininga]

This has already been addressed and will be released as part of version 2.0. If you are able to build from source you can verify that it works for you.