Rick,
On May 19, 4:30 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> Does the same statement work in an interactive query window, complete with
> the embedded semicolon you're using?
>
> Also, you should be able to use positional parameters instead of named
> parameters in your call:
> cur.execute("execute stored_proc 'gra%' ")
>
> Note that as of yet there is no SQLAlchemy support for OUT or IN/OUT
> parameters; currently you can return a single set of results via a SELECT in
> the stored procedure.
>
> Rick
The SQL works in our SQL analyzer with or without the named parameter
and with the semicolon. We tried it the way you mentioned too, using
positional parameters, and got the same error. I apologize for
forgetting to mention that in my first post.
Any other ideas? I'll look into the OUT parameter that Bayer mentions
in his post.
Mike
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
