Hi. I'm trying to track down a problem, and I'm wondering if the following
two statements are appreciably different? I would have thought they were
equivalent:
(1) result = engine.execute(myQuery)
(2) result = text(myQuery, engine).execute()
"myQuery" is a string containing a big, hairy SQL query that can take a
couple of hours to run under Oracle 10 before returning a ResultProxy
object. When using the first statement above, I'm always getting this Oracle
error:
File "/swu/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line
931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-01652: unable to extend
temp segment by 128 in tablespace TEMP
The query always runs fine, however, when I use the second statement.
|>ouglas
P.S. I fully understand that the phenomenon I'm observing could be
completely coincidental, as it's difficult to confirm the correlation when
each attempt takes several hours.
--
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.
