you likely want to use cx_oracle directly so that you can use callproc():
https://cx-oracle.readthedocs.io/en/latest/user_guide/plsql_execution.html
to access the cx_oracle cursor see the guidelines at
https://docs.sqlalchemy.org/en/13/core/connections.html#calling-stored-procedures
you might
Question 1:
I don't think there is a good fancy way of doing this built in to
SQLAlchemy. With your constraint of using a stored proc for inserts (we
have a similar constraint where I work), one way around the
multiple-command overhead would be to do a bulk insert to a temporary
"parameters"
On Wednesday, October 21, 2020 at 1:11:06 PM UTC-4 Terrence-Monroe: Brannon
wrote:
>
> Question 2 - If we adopt a naive approach of opening a transaction, making
> 1000 calls to this stored proc that does simple inserts, and then commiting
> to database at the end of the 1000 calls to the