MySQL Forums :: Stored Procedures :: Procedure does not exist -- when it does.


Advanced Search

Re: Procedure does not exist -- when it does.
Posted by: Peter Brawley ()
Date: October 06, 2016 11:50AM

> an error ... that the stored procedure does not exist, for each schema.

I do not understand "each schema", sprocs are defined within schemas.

What's SQL SECURITY for the sproc?

What's the result of ...

select *
from information_schema.routines
where routine_name = 'sprocname';

Can you run the sproc as root? What does the mysql.proc row have for the routine? Can you duplicate the error as the logged-in user?

Options: ReplyQuote


Subject Views Written By Posted
Procedure does not exist -- when it does. 2154 Carl Roberts 09/26/2016 09:10AM
Re: Procedure does not exist -- when it does. 270 Peter Brawley 09/26/2016 09:56AM
Re: Procedure does not exist -- when it does. 248 Carl Roberts 09/26/2016 10:04AM
Re: Procedure does not exist -- when it does. 266 Peter Brawley 10/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.