I am experimenting with autoloading tables from Oracle (9.2) running on a
remote machine. Normal selects using cx_Oracle work just fine. Here is
what I get:
>>> from sqlalchemy import *
>>> eng = create_engine('oracle:// .......')
>>> md = BoundMetaData(eng)
>>> g2r = Table('gene2refseq',md,autoload=True)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "build/bdist.linux-x86_64/egg/sqlalchemy/schema.py", line 143, in
__call__
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 505,
in reflecttable
File "build/bdist.linux-x86_64/egg/sqlalchemy/databases/oracle.py", line
214, in reflecttable
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 255,
in execute
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 259,
in execute_text
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 329,
in _execute_raw
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 348,
in _execute
sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-01008: not all variables
bound
'select distinct OWNER from ALL_TAB_COLUMNS where TABLE_NAME = :table_name'
{'table_name': 'GENE2REFSEQ'}
Any thoughts?
Thanks,
Sean
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
