Hello I created a PLSQL procedure to update or insert quantity in inventory table based on product Id and new inward qty. Below is my PLSQL procedure and it works fine when i try in sql developer. But when i trying to execute this in python it is stopped working and froze Kindly help. PLSQL Procedure: Python program to call
Tag: stored-procedures
Python code doesn’t run the SQL stored procedure completely
I am not proficient in Python but I have written a python code that executes a stored procedure (SQL server) which within it contains multiple stored procedures therefore it usually takes 5 mins or so to run on SSMS. I can see the stored procedure runs halfway through without error when I run the Python code which makes me think
Is it possible to set a jupyter notebook chunk to run with a certain delay after the previous one?
I have the following 2 chunks. Once the first chunk gets executed in python it seems to me that it takes time for the stored procedure to execute in sql. Before that is done, however, python moves immediately to next chunk. Is it possible to delay running of the next chunk by say 5 minutes? Answer I’m not sure if