Ok, so this looks impossible to me, but it's happening. I figure people with more experience debugging SA might be able to help.
I've got a generated query (no ORM). I was using 0.3.7 with no problems, but thought I'd give .4 a try to see if I can take advantage of performance improvements. From reading the migration documentation it appeared all I really needed to do was change:: meta = BoundMetaData(engine) to:: meta = MetaData(engine) So I did that and now when I run my query now it throws an error:: ... File "/home/matt/work/vpython/lib/python2.4/site-packages/SQLAlchemy-0.4.0beta5-py2.4.egg/sqlalchemy/engine/base.py", line 867, in _cursor_execute raise exceptions.DBAPIError.instance(statement, parameters, e) sqlalchemy.exceptions.DatabaseError: (DatabaseError) ORA-00932: inconsistent datatypes: expected NUMBER got CLOB In my log file, it appears that the statement generated for 0.3.7 and 0.4.0beta5 is the same. The parameters differ a little. One key is somehow converted (incorrectly) to a float instead of a string (like it was in 0.3.7). I thought that might be the problem, but that is the opposite of what the error message is. So after digging/stepping through SA for a bit (hey, at least I learned how to use pdb from emacs!), I didn't see anything useful. Then I tried running the query using only cx_Oracle. I used the same statement and parameter from the 0.4.beta5 version and lo and behold, it worked!?!?! (I even changed the parameter that was a float to a string and it still worked...) So now I'm just confused. I'm not sure how the same query can work from straight cx_Oracle, but fails with the _CursorFairy tries to execute it... Has something/much changed with Oracle since 0.3.7 (I know it's ~6 months old)? The Changelog [0] lists "oracle improvements" in beta2, "auto_convert_lobs" in 0.3.9.... Could these be responsible? Any hints or suggestions would be great! Thanks much. I'm just confused right now, and would like to leave that state ;) -matt 0 - http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/CHANGES --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---