Error 1607 Cannot create stored routine
Hello!
I can't create simple storage procedure in "MySQL Administrator".
OS: Windows XP SP2
MySQL 5.1.23
Developer machine configuration.
user: root
I try to execute:
CREATE PROCEDURE `database1`.`test` ()
BEGIN
END
And receive:
Error while executing query.
CREATE PROCEDURE `database1`.`test` ()
BEGIN
END
MySQL Error Number 1607
Cannot create stored routine `test`. Check warnings
What I do wrong? And how I can create stored procedure? A can manually insert record to `proc` table in `mysql`. Why I can't do this by MySQL Administrator?
Subject
Views
Written By
Posted
Error 1607 Cannot create stored routine
17665
February 21, 2008 03:58AM
6941
February 21, 2008 09:48AM
6196
February 22, 2008 08:11AM
10231
February 22, 2008 10:09AM
5564
February 25, 2008 02:48AM
5173
February 28, 2008 09:06AM
4947
February 28, 2008 09:22AM
4967
February 28, 2008 10:28AM
4741
February 28, 2008 11:00AM
3977
March 03, 2008 12:59PM
3759
March 05, 2008 11:07AM
3452
March 14, 2008 11:56AM
3056
May 11, 2008 04:57AM
2683
May 23, 2008 10:26PM
2976
May 31, 2008 02:05PM
3374
May 31, 2008 07:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.