add the autocommit=True flag to your text() construct, or use an
explcit begin()/commit() call with the connection.
On Feb 19, 2009, at 3:28 PM, jack2318 wrote:
Hi,
I am running following test:
conn = engine.connect()
conn.execute(text(CALL SP_SA_TEST(4)))
conn.close()
engine
Thanks. autocommit flag did the trick. BTW is it the best way of
calling stored procedures?
-- jacek
On Feb 19, 12:48 pm, Michael Bayer mike...@zzzcomputing.com wrote:
add the autocommit=True flag to your text() construct, or use an
explcit begin()/commit() call with the connection.
On
with firebird engine I have to write:
this_sql = myengine.text("select * from my_procedure(:field1,
:field2, :field3)",
bindparams=[
bindparam('field1', value=100),
bindparam('field2', value=200),
bindparam('field3', value=300)]
)
this don't works:
this_sql =
Michael Bayer wrote:
the func keyword is used for stored procedures. in the latest
trunk, you can also create table-like elements out of funcs to
support multi-column stored procedures, and you can create the SQL
corresponding to the patterns you describe.
That's pretty cool, too bad I