<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">Traceback (most recent call last):<br>
File "./scripts/reflect_models.py", line 162, in <br>
main()<br>
File "./scripts/reflect_models.py", line 153, in main<br>
t = get_table(name, metadata, owner=user)<br>
File "./scripts/reflect_models.py", line 127, in get_table<br>
return sqlalchemy.Table(table_name, metadata, **kwargs)<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/schema.py", line 175, in <strong>call</strong><br>
metadata._get_engine(raiseerr=True).reflecttable(table)<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/engine/base.py", line 806, in reflecttable<br>
self.dialect.reflecttable(conn, table)<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/databases/oracle.py", line 358, in reflecttable<br>
row = c.fetchone()<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/engine/base.py", line 1024, in fetchone<br>
return self._process_row(row)<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/engine/base.py", line 1109, in _process_row<br>
row = [i) for i in xrange(len(row))](sup._get_col(row,)<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/engine/base.py", line 993, in _get_col<br>
return rec<a href="1">1</a>.convert_result_value(row[rec<a href="rec%5B2">2</a>], self.dialect)<br>
File "/tmp/sa_ora_reflect_error/src/sqlalchemy/lib/sqlalchemy/databases/oracle.py", line 117, in convert_result_value<br>
return value.read()<br>
AttributeError: 'str' object has no attribute 'read'</p>
<p dir="auto">When trying to troublshoot this bug, it appears, for the schema I have, it last worked in 0.3.8.  Will attach a patch, taken from trunk, which works.</p>
<hr>
<p dir="auto">Attachments: <a href="../wiki/imported_issue_attachments/751/oracle_reflection.diff">oracle_reflection.diff</a></p>
<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">when reflecting from existing firebird table sqlalchemy reflects INTEGER fields as being BIGINT and BIGINT fields as NUMERIC</p>