I get the following traceback: >>> conn.execute(sqlalchemy.func.myfunc('1', '2')) Traceback (most recent call last): File "<interactive input>", line 1, in <module> File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg \sqlalchemy\engine\base.py", line 824, in execute return Connection.executors[c](self, object, multiparams, params) File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg \sqlalchemy\engine\base.py", line 858, in _execute_function return self._execute_clauseelement(func.select(), multiparams, params) File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg \sqlalchemy\engine\base.py", line 874, in _execute_clauseelement return self.__execute_context(context) File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg \sqlalchemy\engine\base.py", line 896, in __execute_context self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context) File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg \sqlalchemy\engine\base.py", line 950, in _cursor_execute self._handle_dbapi_exception(e, statement, parameters, cursor, context) File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg \sqlalchemy\engine\base.py", line 931, in _handle_dbapi_exception raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) DatabaseError: (DatabaseError) ORA-14551: cannot perform a DML operation inside a query
'SELECT myfunc(:myfunc_2, :myfunc_3) AS myfunc_1 FROM DUAL' {'myfunc_2': '1', 'myfunc_2': '2'} The select is the problem. Leaving aside the issue of whether its a good idea to modify data inside a function, is there a way to do this using sqlalchemy? And if so, what is the preferred syntax/style? cheers --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---