Error 1305: does not exist
You are viewing an old version of this article. View
the current version here.
| Error Code | SQLSTATE | Error | Description |
|---|---|---|---|
| 1305 | 42000 | ER_SP_DOES_NOT_EXIST | %s %s does not exist |
Contents
Possible Causes and Solutions
This error is returned when what is being called called does not exist. For example:
CALL Reset_animal_count(); ERROR 1305 (42000): PROCEDURE test.Reset_animal_count does not exist SELECT Reset_animal_count(); ERROR 1305 (42000): FUNCTION test.Reset_animal_count does not exist
There are a number of possible causes:
- The stored procedure or stored function has not yet been created. See CREATE PROCEDURE or CREATE FUNCTION
- There was a typo in the name. Check also that the case is correct. See Identifier Case-sensitivity. For example:
CALL Reset_animal_count(); ERROR 1305 (42000): PROCEDURE test.Reset_animal_count does not exist CALL reset_animal_count(); Query OK, 0 rows affected (0.001 sec)
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
