Thanks Michael for the reply. I am not sure what version of cx_Oracle it is - it was downloaded as a Windows binary - the latest version is 5.1 on the cx_Oracle download page.
I did manage to solve the other problem though, but I don't know why I needed a fix. In the vanilla cx_Oracle code, I used the exact same connect string (with the Oracle service name), and ran the query and it worked fine. In sqla I had to give it a namespace definition (which I figured out by accident by browsing the tables from a third party tool), and then the exact same "MERCHANT" worked. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/F_2vi1VxE28J. 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.