Procedure does not exist -- when it does.
I have an application where it is critical that a certain stored procedure runs each morning for my clients, each day. For the past five days, though, I have been receiving an error (that I email myself) that the stored procedure does not exist, for each schema.
However, the procedure DOES exist, and when I run the cron job manually, it runs perfect. Is there a known issue where stored procedures just stop existing, or any thoughts on a reason why?
It's created correctly, with the correct privileges, table names, etc.; works flawlessly when run through the cron job (same exact code it gets the error on), and manually through a MySQL client.
Subject
Views
Written By
Posted
Procedure does not exist -- when it does.
13418
September 26, 2016 09:10AM
3101
September 26, 2016 09:56AM
2461
September 26, 2016 10:04AM
2439
October 06, 2016 11:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.