title: 1305 - PROCEDURE db.delete_catelog_item does not exist
body: <p>I just created a procedure <code>(name : 'delete_catelog_item does')</code> in the database <code>(name : db)</code> and tried to run that procedure.Then i get an error like this <code>#1305 - PROCEDURE db.procedurename does not exist</code> .</p>
  
  <p>My Query</p>
  
  <pre><code>DELIMITER //
  CREATE DEFINER=`root`@`localhost` PROCEDURE `delete_catelog_item`(IN itemtocatid INT(11),IN shopinid INT(11),OUT out_put BOOL)
  BEGIN
       DECLARE cont INT(11);
       DECLARE itemid INT(11) DEFAULT 0;
       SELECT a.ItmId INTO itemid FROM mas_shop_item_to_category as a INNER JOIN mas_shop_item as b ON (a.ItmID=b.ItmID AND b.IsDelete!=1 AND b.ShopID IN (SELECT ShopID FROM mas_shop WHERE ShopID=shopinid OR ParentID=shopinid)) WHERE a.ItmToCatID=itemtocatid AND a.IsDelete!=1;
       IF itemid!=0 THEN
               UPDATE  mas_shop_item_to_category SET `IsDelete` = '1' WHERE ItmToCatID=itemtocatid;
               SELECT count(ItmToCatID) INTO cont  FROM mas_shop_item_to_category WHERE ItmId=itemid AND IsDelete!=1;
               IF cont=0 THEN
                  UPDATE mas_shop_item SET `IsDelete` = '1' WHERE ItmID=itemid;
               END IF;
               SET out_put=TRUE;
       ELSE
               SET out_put=FALSE;
       END IF;
  END //
  DELIMITER ;
  
  
  Apache/2.2.14 (Ubuntu)
  MySQL client version: 5.1.41
  PHP extension: mysql
  </code></pre>
  
  <p>I can't figure out the actual reason, but when i check the procedure in my database it was there.
  Please help to find the issue.</p>
  
  <p>thank you.</p>