can't call procedure

[Peter Chang]

Hi, I have fully configured mysql 5 with user & db tables.
(have all privileges on *.*, also reloaded mysql, too.)

- - - - -
mysql> delimiter //
mysql> create procedure cc() BEGIN select * from aaa; END//
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call cc();
ERROR 1305 (42000): PROCEDURE abc.ss does not exist
mysql> select * from aaa;
+------+------+------+
| no | id | pin |
+------+------+------+
| 1 | 111 | 10 |
| 2 | 222 | 20 |
+------+------+------+
2 rows in set (0.00 sec)

mysql>

What should I do? I have installed clean source and new statement Directories..



Edited 1 time(s). Last edit at 04/15/2005 06:20AM by Peter Chang.