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
-~----------~----~----~----~------~----~------~--~---

Reply via email to