Monday 3 September 2018

Mysql The stored procedure does not exist

I create stored procedure from mysql client terminal and everything is OK. But when I try to call it i get this error message:

ERROR 1305 (42000): PROCEDURE XXX does not exist
After that i try to create it again without
DROP PROCEDURE IF EXISTS
statement and I get this:
ERROR 1304 (42000): PROCEDURE XXX already exists
What's wrong?
*THE PROBLEM WAS THAT MY DATABASE HAVE POINT (.) IN NAME *
*EXAMPLE: 'site.db' -> THIS IS WRONG NAME OF DATABASE AND MYSQL CAN'T FIND PROCEDURE !!!*

Possibly you have problems with consistency of your system databases after incorrect upgrade or something like that. What are results for
select * from information_schema.ROUTINES where routine_name = 'xxx'

0 comments:

Post a Comment