ho un problema con le SP create:
codice:
mysql> show procedure status;
+---------+-------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db      | Name        | Type      | Definer | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+---------+-------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| library | getAuthor() | PROCEDURE | root@%  | 2011-04-18 10:09:46 | 2011-04-18 10:09:46 | DEFINER       |         | utf8                 | utf8_general_ci      | utf16_bin          |
| library | getBook()   | PROCEDURE | root@%  | 2011-04-18 10:09:09 | 2011-04-18 10:09:09 | DEFINER       |         | utf8                 | utf8_general_ci      | utf16_bin          |
| library | getEditor() | PROCEDURE | root@%  | 2011-04-18 10:10:13 | 2011-04-18 10:10:13 | DEFINER       |         | utf8                 | utf8_general_ci      | utf16_bin          |
+---------+-------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.00 sec)

mysql> call getBook();
ERROR 1305 (42000): PROCEDURE library.getBook does not exist
mysql> drop procedure library.getBook;
ERROR 1305 (42000): PROCEDURE library.getBook does not exist
in pratica esistono ma nn posso richiamarle ne cancellarle perchè dice che nn esistono.