[sqlalchemy] Oracle Connection Oddities

2011-07-14 Thread Burhan
Platform: Windows XP Oracle : 10.2.0.4.0 SQLAlchemy: 0.7 Python: 2.7 Driver: cx_Oracle (compiled with unicode support as per the Windows binary) My problem is that when I try to do introspection, sqla refuses to connect with this error: cursor.execute(SELECT 0.1 FROM DUAL) TypeError: expecting

Re: [sqlalchemy] Oracle Connection Oddities

2011-07-14 Thread Michael Bayer
Burhan wrote: Platform: Windows XP Oracle : 10.2.0.4.0 SQLAlchemy: 0.7 Python: 2.7 Driver: cx_Oracle (compiled with unicode support as per the Windows binary) What version is in use here? Is the unicode support as per the Windows binary you refer to cx_oracle's UNICODE mode (im

Re: [sqlalchemy] Oracle Connection Oddities

2011-07-14 Thread Burhan
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

Re: [sqlalchemy] Oracle Connection Oddities

2011-07-14 Thread Ian Kelly
On Thu, Jul 14, 2011 at 12:53 PM, Burhan burhan.kha...@gmail.com wrote: 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. import cx_Oracle print cx_Oracle.version -- You received this message