title: Stored procedure does not exist, even after creating it
body: <p>I am trying to create a mysql stored procedure . I have successfully created a procedure using the following code :</p>
  
  <pre><code>delimiter $$
  CREATE PROCEDURE `myprocedure` (IN
   var1 DATE) 
  BEGIN 
  &lt;---code--&gt; 
  END
  </code></pre>
  
  <p>And </p>
  
  <pre><code>SHOW CREATE PROCEDURE myprocedure
  </code></pre>
  
  <p>shows me the procedure I have created.</p>
  
  <p>But the Call myprocedure(2011-05-31);</p>
  
  <p>shows me the following error </p>
  
  <pre><code>#1305 - PROCEDURE db.myprocedure does not exist
  </code></pre>
  
  <p>db is database where I have created the procedure</p>
  
  <p>What mistake am I doing?</p>
  
  <p>Can anyone help me in this?</p>