[Sqlalchemy-tickets] Issue #4023: SQLAlchemy with cx_oracle does not recognize UROWID type (zzzeek/sqlalchemy)

[Peter K. <iss...@bi...>]

New issue 4023: SQLAlchemy with cx_oracle does not recognize UROWID type
https://bitbucket.org/zzzeek/sqlalchemy/issues/4023/sqlalchemy-with-cx_oracle-does-not

Peter Karimeddini:

Database: **Oracle 11g**
Relevant substring of error message: *python3.5/site-packages/sqlalchemy/dialects/oracle/base.py:1334: SAWarning: Did not recognize type 'UROWID' of column*

Oracle's UROWID is a type for referring to either the logical or physical address of a row. I am reading reference tables (and thus have no control over the DB design nor can I read the actual data), one of which contains rule exceptions for specific rows across many unrelated tables (hence using UROWID since you can't FK to multiple tables). Even if this was just implemented as Binary, it would be appreciated, as I can't load this table since the UROWID column is the PK.