Hello, I work with sqlalchemy 0.5.2, python 2.5 and Oracle 8.17.
Consider the following code: ora = create_engine('oracle://user:passw...@server/INSTANCE', use_ansi=False, label_length=None) metadata = MetaData(bind=ora) part_list_table = Table('part_list', metadata, Column('$COID', COIDtype(8), key='coid', primary_key=True), include_columns=['$COID', 's_part_number'], autoload=True, schema = 'DMAGS1' ) sel = part_list_table.select( part_list_table.c.coid == '543392B3A4626F76' ).execute() cursor = iter(sel) part = cursor.next() The last instruction raises an exception: ...DatabaseError: (DatabaseError) ORA-01036: illegal variable name/ number 'SELECT "DMAGS1".part_list.s_part_number, "DMAGS1".part_list."$COID" \nFROM "DMAGS1".part_list \nWHERE "DMAGS1".part_list."$COID" = : $COID_1' {'$COID_1': 'T3\x92\xb3\xa4bov'} This is due to the bind parameter name “$COID_1”. The ‘$’ character is not allowed in this context. I get the same error from sqlplus, and the python script works fine when I select on the column ‘s_part_number’. I tried to use ‘label_length=5’ in create_engine, but it generates the bind parameter name ‘_1’, which is rejected by oracle for the same reason. Does anyone know a workaround? Changing the column name is not a option. Thanks, Philippe --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---