Hi ! I have created a stored proecedure in postgreSQL and i would like to call it in my python code. Someone could help?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Odgovori
5765
Prikazi
Hello,
You can write as following :
self._cr.execute("select * from procudure_name(%s);"%(value))
¿Can you translate the stored procedure to ORM? Call stored procedure is not the best solution.
But if not, you can make a get request to external service
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Prijavi