Re: Procedure does not exist -- when it does.

[Peter Brawley]

> 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?