MySQL Forums
Forum List  »  Stored Procedures

CREATE PROCEDURE fails (???)
Posted by: Arly Berg
Date: December 29, 2005 05:27AM

Hi

I have run into a problem which i'm not able to solve, although I've done a lot of research. Hopefully some of you guys can bring light in the darkness :-)

I've have created a stored procedure using "MySQL Query Browser". By executing it not a sign of anything goes wrong.

Here's the problem indicators:
* Looking back at the schema afterwards at right side of MySQL QB: No sign of a stored procedure ....
* Querying the information_schema: Yes, there is an entry for the procedure in the routine table...
* Calling it from the command line: "Sorry, that procedure don't exists...."
* SHOW PROCEDURE STATUS includes the 'non-existing' procedure :-?

I'm using MySQL QB V1.1.14, MySQL 5.1 Beta.


Anybody knowing the reason for this?

Options: ReplyQuote


Subject
Views
Written By
Posted
CREATE PROCEDURE fails (???)
1821
December 29, 2005 05:27AM
1401
December 30, 2005 07:53AM


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.