You can create and schedule a job in Oracle with the procedure you want. Here’s the best example for your reference