Stored procedure 'there' but doesn't exist
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?
Subject
Views
Written By
Posted
Stored procedure 'there' but doesn't exist
3094
May 08, 2015 03:20AM
1001
May 08, 2015 10:58AM
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.