I can reproduce the problem with the 2 hours sleep procedure. I scheduled it to run every 4 hours and it's stuck running since 4 PM yesterday (The firts time it ran).
I also tried to run it with a 2 minute sleep and it completed successfully.
The Oracle Server version is 188.8.131.52.
The Oracle client version was 184.108.40.206 on our VisualCron TEST server and 220.127.116.11 on our PROD server. To make sure the problem on the PROD server is not related to the Oracle client, I uninstalled it and installed version 18.104.22.168 and we still have the same problem.
I'm not sure what you mean here: "Can you also tell us if you can refresh stored procedures correctly in the interface?"
Here is the connection String:
Data Source=BICJTEST;User Id=HIDDEN;Password=**********;Unicode=true;
This is what we have in tnsnames.ora on the VisualCron server:
Edited by user
| Reason: Not specified