How can I call a stored procedure that modifies the data? The
difference from any other stored procedure is that I have to commit
the changes.
I tried the following:
query = sql.func.my_stored_procedure(some_parameter)
trans = conn.begin()
try:
conn.execute(query)
except:
trans.rollback()
raise
trans.commit()
I got an exception:
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 246, in
execute
KeyError: <class 'sqlalchemy.sql.CompareMixin'>
As many other exceptions this is not informative. Does anybody know
how to accomplish the task?
Thank you.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
