MySQL Forums
Forum List  »  Stored Procedures

Stored procedure 'there' but doesn't exist
Posted by: Graham Horner
Date: May 08, 2015 03:20AM

In attempting to migrate a database from 5.1 to 5.6 I get an error:

PROCEDURE MakePostcodesWithSpaces does not exist.
SQL Error: 1305

This procedure does not show up in Workbench and a DROP PROCEDURE gives me the same error, but if I try to create a new procedure with the same name, it says Selected name conflicts with existing procedure 'MakePostcodesWithSpaces'.

How do I get rid of it or recover the code?

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored procedure 'there' but doesn't exist
3094
May 08, 2015 03:20AM


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.