How to call the stored procedure with parameters in python?

Question

I have a stored procedure defined escalate which taking a string parameter clientid.

I'm using sqlalchemy in python and using ORM. I have db.session created.

I'm not sure how i could call stored procedure with this session.

Anyone could point me the solution?

I have tried following; but getting an error:

TypeError: get_bind() got an unexpected keyword argument 'param'

Code:

from sqlalchemy import and_, func,text

db.session.execute(text("CALL escalate(:param)"), param=clientid)

Kirk · Accepted Answer · 2019-11-22 03:36:36Z

1

From the docs session.execute needs a dict over kwargs, unlike the connection object which should have worked as you wrote it.

db.session.execute(
    "CALL escalate(:param)",
    {'param': clientid}
)

answered Nov 22, 2019 at 3:36

Kirk

1,85516 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

do you know why i face this error?stackoverflow.com/questions/58987744/… They way i call storedprocedure is right or wrong?