At Thu, 11 Oct 2007 18:28:10 +0200,
Werner F Bruhin wrote:
> My first go at this did not work, it might have to do with
> FB/kinterbasdb as it expects the stored procedures to be called in one
> of these ways.
>
> cur.execute("select output1, output2 from the_proc(?, ?)", (input1, input2))
>
> cur.callproc("the_proc", (input1, input2))
>
Not that this helps, but the above isn't strictly correct, as you can
use the idiom
SELECT output1, output2 FROM the_proc(?,?)
as well, provided that the_proc is a /selectable/ procedure, that is,
it execute at least a SUSPEND in its body.
ciao, lele.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---