if you dont mind relying upon garbage collection to close connections
then you dont have to worry about closing anything. otherwise youd
need to call close() on the connection.
the closest thing to the old behavior of execute() is the _execute_raw
method on Connection:
conn = engine.connect()
cursor = conn.connection.cursor()
result = conn._execute_raw(statement, params, cursor=cursor)
cursor.close()
conn.close()
but this assumes "statement" is a literal SQL string.
support for oracle output parameters should probably be proposed as a
feature, and id likely do it something like:
from sqlalchemy.databases.oracle import OutParam
result = engine.execute(somesql, param1='foo', param2='bar',
param3=OutParam())
p3 = result.executioncontext.get_out_parameter('param3')
oracle could hook in right on line 133 of oracle.py where its already
accessing the cursor/bind parameters in the pre_exec method of
OracleExecutionContext.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
