How to call postgresql stored procedure using sqlalchemy?

Question

I have developed stored procedure in postgresql which accepting 2 parameters & I am calling it using sqlalchemy using below code but getting syntax error.

I have tried sqlalchemy online tutorials.

connection.execute('stored_proce_name ?, ?',  para_1, para_2 )

Getting error like :ProgrammingError('(psycopg2.errors.SyntaxError) syntax error at or near "stored_proce_name "\nLINE 1: stored_proce_name ?, ?\n ^\n')

Pitto · Accepted Answer · 2019-09-24 11:04:45Z

3

Here's how I do it:

result = conn.execute(StoredProc("add", (3, 4), Integer))

answered Sep 24, 2019 at 11:04

Pitto

8,6993 gold badges51 silver badges54 bronze badges

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

5 Comments

Moon Over a year ago

what is meaning for Integer here ?

Pitto Over a year ago

it is referred to the return type

Pitto Over a year ago

Hi @Moon, if my answer was useful for you please consider upvoting it and/or choosing it as final answer. Thanks!

Bartłomiej Popielarz Over a year ago

Hi, where does the StoredProcedure class come from?

Antonio Serrano Over a year ago

What in Earth is StoredProc!

Collectives™ on Stack Overflow

How to call postgresql stored procedure using sqlalchemy?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related