MySQL Forums
Forum List  »  Stored Procedures

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

Written By
September 26, 2016 09:10AM
Re: Procedure does not exist -- when it does.
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.